(SOLVED) Speed up a dbgrid with so many lines
lazarus / 16-Databases

----------------------------------------------------------------------
xinyiman · 2017-08-10 18:53

Hi guys, I have a dbgrid that must display 10000 records. But it is
very slow (over ten seconds). Is there any parameter that can speed up
loading? Something that just loads me a few records at a time based on
the scrollbar?

Thank you

----------------------------------------------------------------------
Handoko · 2017-08-10 19:34

I remember there was a discussion about big database, maybe you will
be interested:
http://forum.lazarus.freepascal.org/index.php/topic,37183.msg249430.ht
ml

----------------------------------------------------------------------
xinyiman · 2017-08-10 19:42

I solved with

TZQuery.FetchRow:=10;

It was really trivial! Sorry

----------------------------------------------------------------------
mangakissa · 2017-08-11 06:28

Or use TSQLQuery.Disablecontrols and TSQLQuery.Enablecontrols