Could you advise how query works with predicates in dept. For instance predicateBetween is used. Is resultset buffered on server side? If yes what is size of buffer? Or does it return record on each fetch operation?
Scan and query results are buffered. The size of the buffer for queries is defined by query-buf-size which defaults to 2 MiB it will send wen the next response would exceed this size. Scans also use 2 MiB buffers, they will send to the clients when the data written to the buffer exceeds 1 MiB.
Tnx for info.