Feat: Fix thread contention during subgraph syncing #10353

Job	Run time
Clippy linting	38s
Check rustfmt style	16s
Run unit tests	22s
Run integration tests	22s
Subgraph Runner integration tests	22s
Build in release mode	40s
	2m 40s

Provide feedback