Recent

« previous next »
Pages: [1]

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

Heinz

  • New Member
  • *
  • Posts: 10
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?  %)
Logged

wp

  • Hero Member
  • *****
  • Posts: 9606
Re: DBGrid not working with big table
« Reply #1 on: October 19, 2021, 06:27:14 pm »
Quote from: Heinz on October 19, 2021, 06:10:52 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.
Logged
Mainly Lazarus trunk / fpc 3.2.0 / all 32-bit on Win-10, but many more...
Pages: [1]
« previous next »
 

TinyPortal © 2005-2018