> I'd like to handle a large SQLite3 database on Android. But > CursorWindow that is used internal of SQLiteCursor has the limitation > for window size (MAX_WINDOW_SIZE). > > Handling large database causes following error message. > > E/CursorWindow( 6330): not growing since there are already 1630 row > (s), max size 1048576 > > Is there any way to handle db greater than MAX_WINDOW_SIZE?
Don't ask for that many rows back at one time. If your query is bigger than MAX_WINDOW_SIZE, your user will find your query results unusable, IMHO. Find a UI pattern that allows the user to navigate into a smaller scope (e.g., browse categories, then query on a category). -- Mark Murphy (a Commons Guy) http://commonsware.com Android App Developer Books: http://commonsware.com/books.html -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
