Recent

Author Topic: Lazarus DbGrid: Load "in demand" records by default ?  (Read 1875 times)

rretamar

  • New Member
  • *
  • Posts: 39
Lazarus DbGrid: Load "in demand" records by default ?
« on: July 30, 2014, 04:09:10 pm »
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 !
« Last Edit: July 30, 2014, 04:11:37 pm by rretamar »

taazz

  • Hero Member
  • *****
  • Posts: 5368
Re: Lazarus DbGrid: Load "in demand" records by default ?
« Reply #1 on: July 30, 2014, 04:16:13 pm »
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?
Good judgement is the result of experience … Experience is the result of bad judgement.

OS : Windows 7 64 bit
Laz: Lazarus 1.4.4 FPC 2.6.4 i386-win32-win32/win64

 

TinyPortal © 2005-2018