Vandana Srivastava Vandana Srivastava - 29 days ago 8
Android Question

How much rows can I insert in a table in SQLite Android?

I've a CSV file of 500 thousand rows.
I've to insert all rows of CSV file into a table created in SQLite Android.
I want to know how much rows I can insert in any table in SQLite?

Answer

From the sqlite3 documentation:

Maximum Number Of Rows In A Table

The theoretical maximum number of rows in a table is 264 (18446744073709551616 or about 1.8e+19). This limit is unreachable since the maximum database size of 14 terabytes will be reached first. A 14 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.

See this for limits and see this question for some performance characterization.