Feat: Fix thread contention during subgraph syncing #10350

Job	Run time
Subgraph Runner integration tests	1m 33s
Check rustfmt style	19s
Run unit tests	1m 25s
Run integration tests	1m 34s
Build in release mode	1m 9s
Clippy linting	2m 2s
	8m 2s

Provide feedback