CODEWITHSUNDEEP
androidsqlitecsvrowsimport-from-csv
Manish Dubey
Manish Dubey

Reputation: 4306

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?

Upvotes: 3

Views: 2603

Answers (3)

Vivek
Vivek

Reputation: 115

Based on your device performance this can be justified. As the size increases you need more RAM and Processing power to run your queries. Unfortunately storing isn't just important retrieving and processing is important too....

Upvotes: 0

av501
av501

Reputation: 6739

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.

Upvotes: 9

iTurki
iTurki

Reputation: 16398

As much as you want. Theoretically, there is no limit.

Upvotes: 2

Related Questions