Maximum number of rows in a sqlite table

by

As of Jan 2017 the sqlite3 limits page defines the practical limits to this question based on the maximum size of the database which is 140 terabytes:

Maximum Number Of Rows In A Table

The theoretical maximum number of rows in a table is 2^64 (18446744073709551616 or about 1.8e+19). This limit is unreachable since the maximum database size of 140 terabytes will be reached first. A 140 terabytes database can hold no more than approximately 1e+13 rows, and then only if there are no indices and if each row contains very little data.

So with a max database size of 140 terabytes you’d be lucky to get ~1 Trillion rows since if you actually had a useful table with data in it the number of rows would be constrained by the size of the data. You could probably have up to 10s of billions of rows in a 140 TB database.

More Related Contents:

  1. Version of SQLite used in Android?
  2. What are the performance characteristics of sqlite with very large database files? [closed]
  3. Copying data from one SQLite database to another
  4. How can I merge many SQLite databases?
  5. How to retrieve the last autoincremented ID from a SQLite table?
  6. How to import load a .sql or .csv file into SQLite?
  7. How to recover a corrupt SQLite3 database?
  8. SQLite UPSERT / UPDATE OR INSERT
  9. How to backup sqlite database?
  10. SQLite insert speed slows as number of records increases due to an index
  11. Convert SQLITE SQL dump file to POSTGRESQL
  12. Limit an sqlite Table’s Maximum Number of Rows
  13. Sqlite in flutter, how database assets work
  14. Android: Where are database files stored?
  15. Can I download an SQLite db on /sdcard and access it from my Android app?
  16. Populate Android Database From CSV file?
  17. Populating Spinner From SQLite Database Android
  18. How to find SQLITE database file version
  19. Predict next auto-inserted row id (SQLite)
  20. Import .csv file to Sqlite in Android
  21. Error in contrasts when defining a linear model in R
  22. GUID vs INT IDENTITY [duplicate]
  23. have address columns in each table or an address table that is referenced by the other tables?
  24. Creating test data in a database [closed]
  25. List of standard lengths for database fields
  26. How to get item count from DynamoDB?
  27. Should a database table always have primary keys?
  28. H2 Database vs SQLite on Android [closed]
  29. What exactly does database normalization do?
  30. Databse architecture (single db vs client specific db) for Building Enterprise Web (RIA) application on cloud

Leave a Comment