[fpc-pascal] TSQLQuery and buffering.
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.
More information about the fpc-pascal