Cursor size limit in Android SQLiteDatabase

by

There’s a limit of 1MB on internal assets due to dynamic decompression; the 1MB limit also seems to apply to Cursor blobs but this doesn’t seem to be documented anywhere.

Generally you should avoid blobs in SQLite as they perform poorly; instead save the blob data as a file and store the location of the file in your DB.

More Related Contents:

  1. Retrieve large blob from Android sqlite database
  2. how to store Image as blob in Sqlite & how to retrieve it?
  3. Android Push Notification (GCM), is there any Daily Limit?
  4. ImageView be a square with dynamic width?
  5. Is there any limit of bundle in Android?
  6. SQLite Android Database Cursor window allocation of 2048 kb failed
  7. android.database.CursorIndexOutOfBoundsException: Index 0 requested, with a size of 0
  8. Why does my app size on device differ than the APK or Play store size
  9. How to check an Android device is HDPI screen or MDPI screen?
  10. Android screen size HDPI, LDPI, MDPI [duplicate]
  11. How can I get the size of a folder on SD card in Android?
  12. What is The use of moveToFirst () in SQLite Cursors
  13. How to get total RAM size of a device?
  14. How to find android TextView number of characters per line?
  15. What is the difference between getWidth/Height() and getMeasuredWidth/Height() in Android SDK?
  16. Images in SimpleCursorAdapter
  17. How to use the LIMIT argument in an SQLite Query with Android
  18. ActionBar text color
  19. Set transparent background of an imageview on Android
  20. Listview Scroll to the end of the list after updating the list
  21. Android Recyclerview vs ListView with Viewholder
  22. Is there a way to keep fragment alive when using BottomNavigationView with new NavController?
  23. Camera activity returning null android
  24. Simulate low network connectivity for Android [closed]
  25. Design Layout For Multiple Screens
  26. Android List view layout Similar to Google play
  27. android show notification with a popup on top of any application
  28. On Android 8.1 API 27 notification does not display
  29. Text size with different resolution
  30. How do I dim the system bar in Android 3.0 (Honeycomb)?

Leave a Comment