Vandana Srivastava Vandana Srivastava - 2 years ago 123
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 Source

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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download