ORMLite’s createOrUpdate seems slow – what is normal speed?

by

This may be the “expected” speed unfortunately. Make sure you are using ORMLite version 4.39 or higher. createOrUpdate(...) was using a more expensive method to test for existing of the object in the database beforehand. But I suspect this is going to be a minimal speed improvement.

If I create 100 new rows then the speed is even slower.

By default Sqlite is in auto-commit mode. One thing to try is to wrap your inserts (or your createOrUpdates) using the the ORMLite Dao.callBatchTasks(...) method.

In by BulkInsertsTest android unit test, the following doInserts(...) method inserts 1000 items. When I just call it:

doInserts(dao);

It takes 7.3 seconds in my emulator. If I call using the callBatchTasks(...) method which wraps a transactions around the call in Android Sqlite:

dao.callBatchTasks(new Callable<Void>() {
    public Void call() throws Exception {
        doInserts(dao);
        return null;
    }
});

It takes 1.6 seconds. The same performance can be had by using the dao.setSavePoint(...) method. This starts a transaction but is not as good as the callBachTasks(...) method because you have to make sure you close your own transaction:

DatabaseConnection conn = dao.startThreadConnection();
Savepoint savePoint = null;
try {
    savePoint = conn.setSavePoint(null);
    doInserts(dao);
} finally {
    // commit at the end
    conn.commit(savePoint);
    dao.endThreadConnection(conn);
}

This also takes ~1.7 seconds.

More Related Contents:

  1. Do small Calculation Task in Background Using RxJava in Most Efficient Way
  2. Why is the Android emulator so slow? How can we speed up the Android emulator? [closed]
  3. Android SQLite database: slow insertion
  4. Why are nested weights bad for performance? Alternatives?
  5. Android – how do I investigate an ANR?
  6. Android webview slow
  7. Timertask or Handler
  8. Is a RelativeLayout more expensive than a LinearLayout?
  9. Android ListView Refresh Single Row
  10. Making the Android emulator run faster
  11. Android Recyclerview vs ListView with Viewholder
  12. How to test the performance of an Android application?
  13. Android onClick in XML vs. OnClickListener
  14. More efficient way of updating UI from Service than intents?
  15. Handling large Bitmaps
  16. Proguard with OrmLite on Android
  17. Android custom view group delegate addView
  18. Most memory efficient way to resize bitmaps on android?
  19. Android xml vs java layouts performance
  20. Glide image loading with application context
  21. How to detect android cpu speed?
  22. Android Cursor with ORMLite to use in CursorAdapter
  23. application content goes behind the navigation bar in android L
  24. How can I reset a autoincrement sequence number in sqlite
  25. Enhance webView performance (should be the same performance as native Web Browser)
  26. How do I layout nested RecyclerViews, while remaining performant?
  27. Some Oreo devices are not getting Push Notification
  28. Get signal strength of WIFI and Mobile Data
  29. Android: RunOnUiThread vs AsyncTask
  30. Android Listview slow down scroll speed

Leave a Comment