Use `ResultStore` by default for task transactions #16749

Job	Run time
docker, python:3.9	4m 52s
Server Tests - python:3.9, postgres:14	3m 39s
docker, python:3.10	4m 36s
Server Tests - python:3.10, postgres:14	3m 34s
docker, python:3.11	4m 26s
Server Tests - python:3.11, postgres:14	3m 19s
docker, python:3.12	4m 51s
Server Tests - python:3.12, postgres:14	3m 39s
Server Tests - python:3.9, sqlite	5m 2s
Server Tests - python:3.10, sqlite	4m 59s
Server Tests - python:3.11, sqlite	4m 42s
Server Tests - python:3.12, sqlite	4m 54s
Client Tests - python:3.9, postgres:14	5m 3s
Client Tests - python:3.10, postgres:14	5m 3s
Client Tests - python:3.11, postgres:14	5m 2s
Client Tests - python:3.12, postgres:14	5m 2s
	1h 12m 43s

Provide feedback