[fpc-pascal] TSQLQuery and buffering.
gpd at gpdnet.co.uk
Mon Mar 27 10:20:20 CEST 2017
>> It may be that UniDirectional is meant to not buffer all rows, but at the moment it certainly seems to.
> Strange, looking at source code it seems to me, that buffering should not happen.
> As far as TUniDirectionalBufIndex should be used and his AddRecord method does not allocate new memory.
Indeed, that's why I can't currently see where the problem lies. It shouldn't buffer the rows/records, but it does... or at least something does and I'm pretty sure it's not my program. I've pared my test program down to the bare minimum of just looping over the result set, but all the actual fetching from the DB and buffering occurs on just the Open call on the TSQLQuery.
More information about the fpc-pascal