Add option to limit max prefetching in MultiScan (#13920) #6260

Job	Run time
build-linux	15m 34s
check-format-and-targets	45s
build-linux-cmake-with-folly	1h 1m 58s
build-linux-make-with-folly	59m 33s
build-linux-cmake-mingw	14m 5s
build-linux-cmake-with-folly-coroutines	1h 1m 59s
build-linux-clang-13-no_test_run	11m 59s
build-linux-unity-and-headers	16m 14s
build-linux-clang10-clang-analyze	19m 43s
build-linux-cmake-with-benchmark	21m 13s
build-linux-make-with-folly-lite-no-test	10m 4s
build-linux-clang-no_test_run	14m 31s
build-linux-release	14m 6s
build-linux-encrypted_env-no_compression	14m 21s
build-linux-gcc-13-no_test_run	10m 28s
build-macos	25m 31s
build-linux-java	16m 46s
build-macos-java	19m 59s
build-macos-java-static-universal	35m 11s
build-linux-java-pmd	5m 23s
build-linux-arm	11m 50s
build-linux-clang10-asan-ubsan	19m 40s
build-linux-mini-crashtest	28m 28s
build-macos-java-static	30m 8s
build-linux-clang13-mini-tsan	23m 47s
build-macos-cmake (true)	1h 20m 20s
build-linux-static_lib-alt_namespace-status_checked	17m 24s
build-linux-java-static	13m 54s
build-macos-cmake (false)	1h 10m 7s
build-windows-vs2022	1h 14m 20s
	13h 39m 21s

Provide feedback