[Lazarus] Writing >1000 TBufDataset records to file is extremely slow

LacaK lacak at zoznam.sk
Mon Mar 27 12:43:19 CEST 2017


>
>>> But now another issue is coming up: If I increase the number of 
>>> records to 40,000 population of records slows down after about 
>>> 10,000 records, speeds up again, and comes to an apparant 
>>> stand-still for 32900 records. After waiting some time the record 
>>> counter (which is incremented in steps of 100 in my demo) goes up to 
>>> 33000. Then I gave up.
>> Try call MergeChangeLog regulary on every 1000 rows for example.
>> If does not help, attach your test program, so we can reproduce ...
>
> Yes, this is the solution. Thank you. MergeChangeLog definitely should 
> be documented in a better way.
You can report bug report about it or add it to wiki yourself
  - There is http://wiki.freepascal.org/TBufDataset but it seems that 
there is only one line of text ;-)
  - in FCL documentation 
http://www.freepascal.org/docs-html/current/fcl/db/index.html I can not 
find TBufDataset at all
L.



More information about the Lazarus mailing list