Lazarus DbGrid: Load "in demand" records by default ?
lazarus / 16-Databases

----------------------------------------------------------------------
rretamar · 2014-07-30 14:09

Hi.
I make a simgle database test application with Firebird 2.1 Database
(the single select instruction retrieve 40000 database records in this
test), a test form with dbnavigator, dbgrid and tsqlquery component. I
surprised to view than dbgrid loads database record dinamically "on
demand" while moving . It is normal ?.

In a similar test with ZeosLib components, all records are reading at
same time en dbgrid and the test is very slow.

Thanks !

----------------------------------------------------------------------
taazz · 2014-07-30 14:16

SQLDB has a property named PacketRecords set it to -1 to force a load
records at once (SQLQuery component).

what is the question for zeos again?