如何从sqlite db加载超过1 MB的数据到android游标?

前端之家收集整理的这篇文章主要介绍了如何从sqlite db加载超过1 MB的数据到android游标?前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
我正在尝试从sqlite数据库加载超过1MB的数据到android游标.在加载时,它会产生以下错误
08-04 11:10:15.813: ERROR/CursorWindow(4465): need to grow: mSize = 2097152,size = 403719,freeSpace() = 209669,numRows = 1
08-04 11:10:15.813: ERROR/CursorWindow(4465): Attempting to grow window beyond max size (2097152)
08-04 11:10:15.813: ERROR/Cursor(4465): Failed allocating 403719 bytes for blob at 0,13
08-04 11:10:15.813: DEBUG/Cursor(4465): finish_program_and_get_row_count row 0
08-04 11:10:15.899: ERROR/CursorWindow(4465): need to grow: mSize = 2097152,numRows = 1
08-04 11:10:15.899: ERROR/CursorWindow(4465): Attempting to grow window beyond max size (2097152)
08-04 11:10:15.899: ERROR/Cursor(4465): Failed allocating 403719 bytes for blob at 0,13
08-04 11:10:15.899: DEBUG/Cursor(4465): finish_program_and_get_row_count row 0
08-04 11:10:15.899: ERROR/CursorWindow(4465): Bad request for field slot 0,0. numRows = 0,numColumns = 14
08-04 11:10:15.899: DEBUG/AndroidRuntime(4465): Shutting down VM.

如果有人知道如何加载大型数据(超过1MB)到Android游标?
谢谢,

不要在数据库中存储500KB的blob.将标识符存储在数据库中,并将blob作为文件放入存储中.如果使用MODE_PRIVATE,则其他进程将无法访问它们.

猜你在找的Sqlite相关文章