CODEWITHSUNDEEP
android
Anju
Anju

Reputation: 9479

is there any max limit for no:of rows while using sqlite?

I have a CSV file which contains around 1200 rows. I was trying to insert it into sqlite db. Around 300 rows only got inserted. Rest didnt...Is there any max limit on no:of rows in a table while using sqlite?

Upvotes: 2

Views: 1291

Answers (3)

Vinay W
Vinay W

Reputation: 10190

There IS a max limit for creating rows in SQLite.

If the table is initially empty, then a ROWID of 1 is used. If the largest ROWID is equal to the largest possible integer (9223372036854775807) then the database engine starts picking positive candidate ROWIDs at random until it finds one that is not previously used. If no unused ROWID can be found after a reasonable number of attempts, the insert operation fails with an SQLITE_FULL error.

check the official SQLite documentation about Auto Increment.

Upvotes: 0

Anju
Anju

Reputation: 9479

Ya.. we can have more than 10000 inserts.. Please refer this link

Upvotes: 0

Balaji
Balaji

Reputation: 285

I tried more than 10000 inserts it worked, also check in android market there is SQL performance check tool which makes more inserts.

Rgds Balaji

Upvotes: 2

Related Questions