Add option to limit max prefetching in MultiScan #6259

Job	Run time
build-linux	15m 29s
build-linux-cmake-with-folly	1h 5m 20s
build-linux-encrypted_env-no_compression	14m 38s
build-linux-cmake-with-folly-coroutines	1h 2m 19s
build-linux-release	13m 59s
build-linux-unity-and-headers	16m 11s
build-macos	28m 26s
build-linux-clang10-clang-analyze	19m 29s
check-format-and-targets	51s
build-linux-clang-no_test_run	14m 22s
build-linux-clang13-mini-tsan	23m 59s
build-linux-gcc-13-no_test_run	10m 4s
build-linux-make-with-folly-lite-no-test	9m 48s
build-linux-mini-crashtest	28m 56s
build-linux-static_lib-alt_namespace-status_checked	17m 5s
build-linux-cmake-mingw	14m 15s
build-linux-clang-13-no_test_run	12m 21s
build-linux-cmake-with-benchmark	21m 9s
build-linux-make-with-folly	56m 27s
build-linux-clang10-asan-ubsan	20m 4s
build-macos-cmake (true)	1h 6m 52s
build-macos-cmake (false)	1h 6m 6s
build-linux-java-static	13m 56s
build-windows-vs2022	1h 14m 41s
build-macos-java	18m 56s
build-macos-java-static	25m 28s
build-macos-java-static-universal	33m 47s
build-linux-java	17m 12s
build-linux-arm	12m 8s
build-linux-java-pmd	3m 46s
	13h 18m 4s

Provide feedback