Insertion of thousands of contact entries using applyBatch is slow

by

Use ContentResolver.bulkInsert (Uri url, ContentValues[] values) instead of ApplyBatch()

ApplyBatch (1) uses transactions and (2) it locks the ContentProvider once for the whole batch instead locking/unlocking once per operation. because of this, it is slightly faster than doing them one at a time (non-batched).

However, since each Operation in the Batch can have a different URI and so on, there’s a huge amount of overhead. “Oh, a new operation! I wonder what table it goes in… Here, I’ll insert a single row… Oh, a new operation! I wonder what table it goes in…” ad infinitium. Since most of the work of turning URIs into tables involves lots of string comparisons, it’s obviously very slow.

By contrast, bulkInsert applies a whole pile of values to the same table. It goes, “Bulk insert… find the table, okay, insert! insert! insert! insert! insert!” Much faster.

It will, of course, require your ContentResolver to implement bulkInsert efficiently. Most do, unless you wrote it yourself, in which case it will take a bit of coding.

More Related Contents:

  1. How to store large blobs in an android content provider?
  2. Android Gallery on Android 4.4 (KitKat) returns different URI for Intent.ACTION_GET_CONTENT
  3. How to use support FileProvider for sharing content to other apps?
  4. CursorLoader usage without ContentProvider
  5. Android fetch all contact list (name, email, phone) takes more then a minute for about 700 contacts
  6. How to get camera result as a uri in data folder?
  7. Convert content:// URI to actual path in Android 4.4
  8. Why does ContentResolver.requestSync not trigger a sync?
  9. Install shows error in console: INSTALL FAILED CONFLICTING PROVIDER
  10. Create and Share a File from Internal Storage
  11. Android KitKat (API 19) – How to write messages in SMS Content Provider, without sending them, from Non-Default App?
  12. How to implement a ContentObserver for call logs
  13. List all camera images in Android
  14. Android error – close() was never explicitly called on database
  15. Using build types in Gradle to run same app that uses ContentProvider on one device
  16. How to remove a contact programmatically in android
  17. CursorLoader not updating after data change
  18. How to restrict content provider data across applications
  19. How to use SMS content provider? Where are the docs?
  20. Multiple Apps use same content provider
  21. can we get chrome browsing history/bookmarks in our android app
  22. Closing the database in a ContentProvider
  23. Create/Copy File in Android Q using MediaStore
  24. get the last picture taken by user
  25. How to retrieve RCS messages from Android Devices
  26. How to check database on not rooted android device
  27. Possible to use multiple authorities with FileProvider?
  28. Content Provider INSTALL_FAILED_CONFLICTING_PROVIDER (installing content provider as a separate apk)
  29. How to get whatsapp Contacts from Android Programmatically?
  30. How to get a contact’s facebook id or url from native contacts / content resolver?

Leave a Comment