Search code examples
databasesqlitesizing

Maximum number of rows in a sqlite table

Give an simple sqlite3 table (create table data (key PRIMARY KEY,value)) with key size of 256 bytes and value size of 4096 bytes, what is the limit (ignoring disk space limits) on the maximum number of rows in this sqlite3 table? Are their limits associated with OS (win32, linux or Mac)

Solution

  • In SQLite3 the field size isn't fixed. The engine will commit as much space as needed for each cell.

    For the file limits see this SO question:
    What are the performance characteristics of sqlite with very large database files?