Bulk Insertion on Android device

by

Normally, each time db.insert() is used, SQLite creates a transaction (and resulting journal file in the filesystem), which slows things down.

If you use db.beginTransaction() and db.endTransaction() SQLite creates only a single journal file on the filesystem and then commits all the inserts at the same time, dramatically speeding things up.

Here is some pseudo code from: Batch insert to SQLite database on Android

try
{
  db.beginTransaction();

  for each record in the list
  {
    do_some_processing();

    if (line represent a valid entry)
    {
      db.insert(SOME_TABLE, null, SOME_VALUE);
    }

    some_other_processing();
  }

  db.setTransactionSuccessful();
}
catch (SQLException e) {}
finally
{
  db.endTransaction();
}

If you wish to abort a transaction due to an unexpected error or something, simply db.endTransaction() without first setting the transaction as successful (db.setTransactionSuccessful()).

Another useful method is to use db.inTransaction() (returns true or false) to determine if you are currently in the middle of a transaction.

Documentation here

More Related Contents:

  1. I am getting this error on my code [closed]
  2. Sqlite for Android
  3. How can I avoid concurrency problems when using SQLite on Android?
  4. How to store(bitmap image) and retrieve image from sqlite database in android? [closed]
  5. Best way to work with dates in Android SQLite [closed]
  6. How do I join two SQLite tables in my Android application?
  7. How can I create a user-defined function in SQLite?
  8. SQLite Android Database Cursor window allocation of 2048 kb failed
  9. Android SQLite: Update Statement
  10. How to delete SQLite database from Android programmatically
  11. How do I create a database in android? [closed]
  12. Full text search example in Android
  13. Android SimpleCursorAdapter doesn’t update when database changes
  14. rawQuery(query, selectionArgs)
  15. How to implement Export sqlite To excel/csv file in android?
  16. How to store and retrieve a byte array (image data) to and from a SQLite database?
  17. SQLite Query in Android to count rows
  18. App Crashes On Startup Due To java.lang.IllegalArgumentException: column ‘_id’ does not exist
  19. How does one check if a table exists in an Android SQLite database?
  20. Attempt to reopen an already-closed object sqlitedatabase
  21. how to save image taken from camera and show it to listview – crashes with “IllegalStateException”
  22. How insert image in room persistence library?
  23. How to view data saved in android database(SQLite)?
  24. SQLite android column not found
  25. SQlite – Android – Foreign key syntax
  26. Inserting values to SQLite table in Android
  27. Queries with prepared statements in Android?
  28. SQLiteOpenHelper onUpgrade() Confusion Android
  29. Using COLLATE in Android SQLite – Locales is ignored in LIKE statement
  30. SQLite Foreign Key

Leave a Comment