In Sqlite database, How to Insert Multiple Rows in Table at same time

How we can insert multiple rows in Sqlite database at same time? I'm using A开发者_运维技巧ndroid with Java.

---

you can use inserthelper, check this blog

---

What you are looking for is bulkInsert. It will allow you to supply an array of ContentValues to insert. See the Android docs for more info:

http://developer.android.com/reference/android/content/ContentResolver.html#bulkInsert%28android.net.Uri,%20android.content.ContentValues%5B%5D%29

---

ContentValues values = new ContentValues();
for(int i = 0; i<=5; i++) {
    values.put(COLUMN_NAME, i);
    values.put(COLUMN_NAME, 0);
    db.insert(TABLE_NAME, null, values);
}

---

Very old post however. When you are trying to do multiple calls to the db such as update or insert, wrap around with transactions. This will make a huge difference in speed.

db.beginTransaction();
try
{
    while(...) 
    {
        // .. do your inserts, updates and deletes here
    }

    // If successful commit those changes
    db.setTransactionSuccessful();
}
finally 
{
    db.endTransaction();
}