[fpc-pascal] TSQLQuery and buffering.

Gary Doades gpd at gpdnet.co.uk
Mon Mar 27 09:02:10 CEST 2017


> From your original message one could think that you were using
> PacketRecords:=-1 which means fetch all records at once, but if you are using the standard setting, which is 10 and yet it is still fetching everything at once, it 
> sounds like a bug to me.

As far as I can tell setting UniDirectional to true also sets PacketRecords to -1. Even if PacketRecords were still 10 though it still buffers the entire result set, but it just fetches 10 rows at a time from the DB server until it has them all.

Thanks,
Gary.




More information about the fpc-pascal mailing list