[fpc-pascal] TSQLQuery and buffering.
Michael Van Canneyt
michael at freepascal.org
Sun Mar 26 17:07:52 CEST 2017
On Sat, 25 Mar 2017, Gary Doades wrote:
>>> I had read about UniDirectional and I have indeed tried this. It doesn't seem to make any significant difference. Looking through the source code for
>>> TBufDataset it looks like UniDirectional just turns off building various indexes/structures etc. and fetches the result set all in one go instead of 10 row chunks.
>>> It still buffers everything in memory.
>> In that case, it is a bug. The very purpose of UniDirectional is exactly NOT to buffer anything, just to keep the current record in memory.
> Ah, OK. I might have another trawl through the sqldb source then to see if it is a simple mistake I can fix or a bigger job.
> I guess I should file a bug report?
Please do. And if you find the cause, please attach a patch :)
More information about the fpc-pascal