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
