Well, one reason is the CursorWindow size limit that Nobu mentioned. If the CursorWindow size limit is a meg, your BLOB can't be more. Not much of a BLOB if you ask me.
More of a BOB. Not that that's a bad thing. On Thursday, August 2, 2012 4:13:35 PM UTC-5, Kostya Vasilyev wrote: > > > 2012/8/3 bob <[email protected]> > >> Sounds like you are messing with BLOBs in a database. Turns out this >> does not work well on Android. >> > > Why not? > > As was already pointed out, not loading a bunch of blobs in a query behind > a ListView should fix the issue with only a small code change -- i.e. > specifying a projection for the query that does not include the blob column. > > -- K > > >> Maybe use files on the SD card instead? >> >> >> >> On Thursday, August 2, 2012 2:14:06 AM UTC-5, Rajis wrote: >> >>> Hi All >>> >>> I am using listview to store more then 50 item into the listview its >>> working but after inserting the 20th item the erros showing in the log cat >>> like this. >>> >>> >>> 08-02 12:50:34.646: E/CursorWindow(5245): not growing since there are >>> already 16 row(s), max size 1048576 >>> 08-02 12:50:34.646: E/Cursor(5245): Failed allocating 69485 bytes for >>> text/blob at 24,8 >>> 08-02 12:50:34.695: D/Cursor(5245): finish_program_and_get_row_**count >>> row 25 >>> 08-02 12:50:35.355: D/Cursor(5245): skip_rows row 8 >>> 08-02 12:50:35.365: E/CursorWindow(5245): need to grow: mSize = 1048576, >>> size = 69485, freeSpace() = 9795, numRows = 16 >>> 08-02 12:50:35.365: E/CursorWindow(5245): not growing since there are >>> already 16 row(s), max size 1048576 >>> 08-02 12:50:35.365: E/Cursor(5245): Failed allocating 69485 bytes for >>> text/blob at 23,8 >>> 08-02 12:50:35.396: D/Cursor(5245): finish_program_and_get_row_**count >>> row 26 >>> 08-02 12:50:35.896: D/Cursor(5245): skip_rows row 7 >>> 08-02 12:50:35.905: E/CursorWindow(5245): need to grow: mSize = 1048576, >>> size = 69485, freeSpace() = 9795, numRows = 16 >>> 08-02 12:50:35.905: E/CursorWindow(5245): not growing since there are >>> already 16 row(s), max size 1048576 >>> 08-02 12:50:35.905: E/Cursor(5245): Failed allocating 69485 bytes for >>> text/blob at 22,8 >>> 08-02 12:50:35.936: D/Cursor(5245): finish_program_and_get_row_**count >>> row 27 >>> 08-02 12:50:36.425: D/Cursor(5245): skip_rows row 6 >>> 08-02 12:50:36.436: E/CursorWindow(5245): need to grow: mSize = 1048576, >>> size = 69485, freeSpace() = 9795, numRows = 16 >>> >>> >>> and also the application is very slow to load. Help me. >>> >> -- >> 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 >> > > -- 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
