When should I do certain SQLite operations on another thread(not the main thread)?

by

General rule for everything: If it’s fast enough, do it on the main thread. If not, use a worker thread.

Unless you have a ridiculously huge database, a single operation almost never warrants a separate thread. Databases in general are designed to scale well, but of course a very big database (10,000+ rows?) will be a bit slower than a small one. 30 rows, however, is nothing.

I would start threading stuff if you have a lot of operations going on, like a bunch of queries, or complicated queries that span several tables.

As with everything – profile your app, and if it’s too slow, optimize. Don’t write an awesome synchronized super-duper multi-core-ready database handler if none of your queries takes longer than 2ms.

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. Android SimpleCursorAdapter doesn’t update when database changes
  13. How to implement Export sqlite To excel/csv file in android?
  14. How to store and retrieve a byte array (image data) to and from a SQLite database?
  15. problem about sqlite database, no such table:
  16. SQLite Query in Android to count rows
  17. Using the LIMIT statement in a SQLite query
  18. How does one check if a table exists in an Android SQLite database?
  19. sqlite encryption for android
  20. Retrieve large blob from Android sqlite database
  21. Attempt to reopen an already-closed object sqlitedatabase
  22. How insert image in room persistence library?
  23. How to view data saved in android database(SQLite)?
  24. Changing values from Cursor using SimpleCursorAdapter
  25. How to store JSON object in SQLite database
  26. sqlite3: not found
  27. Android SQLiteOpenHelper cannot open database file
  28. Getting the type of a column in SQLite
  29. Android table creation Failure (near “autoincrement”: syntax error)?
  30. sqlite insert into table select * from

Leave a Comment