store: Do not hold a connection unnecessarily #9442

Job	Run time
Subgraph Runner integration tests	4m 21s
Run unit tests	7m 52s
Clippy linting	52s
Run integration tests	5m 53s
Build in release mode	1m 51s
Check rustfmt style	5s
	20m 54s

Provide feedback