Android Cursor maximum size

Question

It appears that Cursors in android can only hold up to 1 MB of data.

What would be the most efficient way to pull the maximum number of rows from a table in a SQLite database that stays under the 1 MB limit?

The best way I have come up with so far is to sample a few rows and "estimate" how many rows you can pull. You just have to make sure you never go over the 1MB limit. — zzzzzzzzzzzzzzzzzzzzzzzzzzzzzz, Jun 22 '12 at 18:38
the best method is to use the concept of paging, that means get the data from database in parts ,getting rows ten by ten and clearing the cursor before the next retrieving from database. — deepak825, May 06 '13 at 12:57

score 0 · Answer 1 · answered Jul 18 '13 at 00:10

I don't think there's a hard and fast way to determine the right limit, but I looked in the CursorWindow documentation and found that copyStringToBuffer (int row, int column, CharArrayBuffer buffer) seems promising as CharArrayBuffer has a integer field called sizeCopied and the method copyStringToBuffer takes the text at the specified row and column. Maybe you can get the size from the buffer and add for each row and column you have? If you're using SQLiteCursor, you can use setWindow(CursorWindow window) to set your own window.

score -1 · Answer 2 · answered Jun 22 '12 at 18:27

-1

You can put LIMIT clause, so that rows are fetched in parts.

answered Jun 22 '12 at 18:27

Programmer

5,360
10
37
61

Right but how would I determine what the appropriate limit is? – zzzzzzzzzzzzzzzzzzzzzzzzzzzzzz Jun 22 '12 at 18:29
Then you can divide equally or whatever way you like – Programmer Jun 22 '12 at 18:30
I don't think you understand. I'm trying to find the best way to determine how many rows in an arbitrary table is equal to 1MB. In one table it may be 1000 rows and in another table it may be 500 rows. – zzzzzzzzzzzzzzzzzzzzzzzzzzzzzz Jun 22 '12 at 18:31
Yes but not the size of the rows – zzzzzzzzzzzzzzzzzzzzzzzzzzzzzz Jun 22 '12 at 18:35
This is the way you can acheive this...http://stackoverflow.com/questions/9873869/android-how-to-query-huge-database-in-android-cursor-size-is-limited-to-1mb – Programmer Jun 22 '12 at 18:43
The answers on that last question state that you shouldn't do it. For 99% of applications I would agree, but I have a special need for a non market application where I need to achieve this. – zzzzzzzzzzzzzzzzzzzzzzzzzzzzzz Jun 22 '12 at 18:50

Android Cursor maximum size

2 Answers2