Recent

Author Topic: DBGrid not working with big table  (Read 1312 times)

Heinz

  • New member
  • *
  • Posts: 9
DBGrid not working with big table
« on: October 19, 2021, 06:10:52 pm »
I have a table with 5 rows and DBGrid show instantly the result.
Then I switch query selecting a table of more than 50000 rows and the result are only empty columns (with correct title though).
The same select works on embarcadero sql.

Why?  %)

wp

  • Hero Member
  • *****
  • Posts: 9034
Re: DBGrid not working with big table
« Reply #1 on: October 19, 2021, 06:27:14 pm »
Why?  %)
No idea what you are doing. The attached project creates a dummy sqlite3 database with 1 million records within about 10 seconds, and when the application is opened a second time it loads the table into a dbgrid instantly.
Mainly Lazarus trunk / fpc 3.2.0 / all 32-bit on Win-10, but many more...

 

TinyPortal © 2005-2018