Add option to limit max prefetching in MultiScan #6250

Job	Run time
build-linux-clang-13-no_test_run	12m 9s
build-linux	15m 40s
build-linux-cmake-with-folly	31m 40s
build-linux-cmake-mingw	14m 35s
build-linux-release	14m 16s
build-linux-cmake-with-folly-coroutines	33m 51s
check-format-and-targets	42s
build-linux-make-with-folly-lite-no-test	10m 17s
build-linux-clang-no_test_run	14m 53s
build-linux-cmake-with-benchmark	21m 12s
build-linux-make-with-folly	31m 40s
build-linux-encrypted_env-no_compression	14m 30s
build-linux-java	16m 24s
build-macos-java	20m 53s
build-linux-mini-crashtest	28m 59s
build-linux-gcc-13-no_test_run	10m 10s
build-linux-clang13-mini-tsan	23m 50s
build-windows-vs2022	1h 15m 12s
build-linux-java-static	13m 46s
build-linux-clang10-asan-ubsan	19m 54s
build-macos	23m 14s
build-linux-clang10-clang-analyze	19m 27s
build-macos-java-static-universal	26m 19s
build-linux-java-pmd	1m 56s
build-linux-static_lib-alt_namespace-status_checked	19m 54s
build-macos-java-static	35m 20s
build-linux-arm	12m 18s
build-macos-cmake (true)	1h 12m 20s
build-linux-unity-and-headers	16m 12s
build-macos-cmake (false)	1h 27m 10s
	12h 18m 43s

Provide feedback