Android SQLite and huge data sets

by

what options do we have in querying
and displaying tens of thousands of
rows of data in Android?

You mean besides telling you that reading 20,000+ rows on a 3.5″ LCD is bat-guano crazy? 😉

It looks like CursorWindow, which is used somewhere under the covers, is having issues managing >17,000 rows. That could be one of two things:

  1. You are out of heap space. With a 16MB non-compacting heap, and the fact that a Cursor holds the entire result set in the heap, that is not out of the question.
  2. CursorWindow only supports 1MB of data, which is what the error message suggests more directly.

If there is a logical way to divide your queries into discrete chunks, you could do incremental queries and use CursorJoiner to stitch them together, and see if that helps.

But, in all seriousness, 20,000+ rows in a 3.5″ screen, on a device that most closely resembles a 12-year-old PC in horsepower, is really asking a lot.

More Related Contents:

  1. Date String to Milliseconds [duplicate]
  2. Java/Android – Best way to update apps that are not in the Play Store
  3. How to load a dictionary on android app start and use it from different activities
  4. Translate java widget to kotlin [duplicate]
  5. Sending Email in Android using JavaMail API without using the default/built-in app
  6. org.apache.http.entity.FileEntity is deprecated in Android 6 (Marshmallow)
  7. Any good ORM tools for Android development? [closed]
  8. Getting frames from Video Image in Android
  9. Background service for android oreo
  10. Database not copying from assets
  11. Registering a headset button click with BroadcastReceiver in Android
  12. Universal way to write to external SD card on Android
  13. Access resource files in Android
  14. How to properly use backwards compatible Vector Drawable with the latest Android Support Library?
  15. how to resume an interrupted download – part 2
  16. How to include the Spongy Castle JAR in Android?
  17. Why does BitmapFactory.decodeByteArray return null?
  18. Prevent WebView from displaying “web page not available”
  19. Google SignIn API Exception 10
  20. How to remove all callbacks from a Handler?
  21. How to create your own library for Android development to be used in every program you write?
  22. The activity must be exported or contain an intent-filter
  23. Using “this” with class name
  24. R.raw.anything cannot be resolved [duplicate]
  25. How can I implement Google Play Licensing for an Android app? [closed]
  26. How to implement a button that gets all checkbox’s state and adds the value of checked item into arraylist?
  27. Value of type java.lang.String cannot be converted to JSONArray
  28. Why does super.onDestroy() in java Android goes on top in destructors? [duplicate]
  29. UNIQUE constraint failed: sqlite database : android
  30. Random element from string array [closed]

Leave a Comment