[fpc-pascal] TSQLQuery and buffering.

[Michael Van Canneyt]

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 :)


Michael.