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.
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal