[SOLVED] TDBGrid - What is the maximum capacity when used with SQLite?
lazarus / 16-Databases

----------------------------------------------------------------------
Gizmo · 2021-03-17 16:39

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

----------------------------------------------------------------------
af0815 · 2021-03-17 17:12

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.

----------------------------------------------------------------------
Gizmo · 2021-03-18 16:35

OK, thanks man. Yeah that makes sense.