[fix] : Instead of sending the value scan's batch all at once, split it up to reuse memory.

[fix] : Instead of sending the value scan's batch all at once, split it up to reuse memory. #22020