Recent

« previous next »
Pages: [1]

Author Topic: [SOLVED] TDBGrid - What is the maximum capacity when used with SQLite?  (Read 1227 times)

Gizmo

  • Hero Member
  • *****
  • Posts: 831
[SOLVED] TDBGrid - What is the maximum capacity when used with SQLite?
« on: March 17, 2021, 05:39:09 pm »
Does TDBgrid have a maximum value for rows\capacity? I am using SQLite with it, and a user has asked about the maximum number of entries if there were to be millions, or even billions, of rows. SQLite has a maximum row count of 2^64 (18,446,744,073,709,551,616) which is larger than the max size of a database (140Tb) from what I have read. But I am assuming TDBGrid has a different (perhaps lower, 32-bit limited?) limit?

Have looked here but no mention of maximum limits https://wiki.freepascal.org/TDBGrid

Thanks
« Last Edit: March 18, 2021, 05:35:06 pm by Gizmo »
Logged

af0815

  • Hero Member
  • *****
  • Posts: 1404
Re: TDBGrid - What is the maximum capacity when used with SQLite?
« Reply #1 on: March 17, 2021, 06:12:05 pm »
This will not a problem for DBGrid, because it shows only a window of the underlaying Dataset. Normally only a subset of rows is normally fetched from the server, not all data.
Fetching of millions rows in a dataset is normally a design no go. It makes no sense.
Logged
regards
Andreas

Gizmo

  • Hero Member
  • *****
  • Posts: 831
Re: [SOLVED] TDBGrid - What is the maximum capacity when used with SQLite?
« Reply #2 on: March 18, 2021, 05:35:18 pm »
OK, thanks man. Yeah that makes sense.
Logged
Pages: [1]
« previous next »
 

TinyPortal © 2005-2018