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?
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.