enh(Any): reduce memory usage for small object optimisation. #2764

Job	Run time
android-arm64-v8a-ndk-cmake	8m 26s
android-arm64-v8a-ndk-latest-cmake	8m 30s
android-armeabi-v7a-ndk-cmake	8m 9s
linux-emscripten-cmake	4m 53s
linux-gcc-cmake	17m 5s
linux-gcc-cmake-unbundled	17m 10s
linux-gcc-make	21m 10s
linux-gcc-make-armv7l	14m 26s
linux-gcc-make-asan	27m 26s
linux-gcc-make-asan-no-soo	26m 40s
linux-gcc-make-cross-armhf	14m 55s
linux-gcc-make-cxx20	27m 33s
linux-gcc-make-mongodb	8m 22s
linux-gcc-make-mysql	8m 27s
linux-gcc-make-odbc	13m 8s
linux-gcc-make-postgres	8m 20s
linux-gcc-make-redis	8m 21s
linux-gcc-make-sqlite-no-sqlparser	8m 14s
linux-gcc-make-trace	22m 26s
linux-gcc-make-tsan	22m 3s
linux-gcc-make-ubsan	31m 56s
macos-clang-cmake-openssl3	21m 30s
macos-clang-cmake-openssl3-visibility-hidden	21m 54s
macos-clang-make	38m 45s
macos-clang-make-openssl3-asan	32m 38s
macos-clang-make-openssl3-tsan	23m 1s
macos-clang-make-openssl3-ubsan	38m 42s
macos-clang-make-visibility-hidden	31m 42s
windows-2022-msvc-buildwin-x64	37m 6s
windows-2022-msvc-cmake	22m 33s
	9h 55m 31s

Provide feedback