Hello,
We are trying to query a table with 7011 records (simply first calling
sqlite3_prepare16_v2 and then sqlite3_step, nothing complicated that is). It
appears sqlite3_step returns SQLITE_ERROR if result sets contain records
more than a certain size. The very 3.8.4.1 version on Windows desktop
appears to work ok with the same data set. It successfully returns
relatively larger number of records.
Quick questions :
1) We are compiling SQLite into a DLL and using it in our application.
Could there be some compilation settings issues we are not getting right
(only defs we are using SQLITE_OS_WINRT, and SQLITE_ENABLE_COLUMN_METADATA)
?
2) Could this be related to memory issue on WinRT/Windows Phone 8 ? We
tried to increase cache_size (experimented with 4000), but it did not help
(sqlite initially reports the cache size being 2000, by default, as
expected).
Any input or comments will be greatly appreciated. Also the same issue is
being experienced with only a few records where the records do contain blobs
(images around 1 MB in size).
Regards,
MB
// The following statement fails as it tries to return 3728 records
SELECT PRD_DETAILS.APN1,
PRD_DETAILS.APN2,
PRD_DETAILS.APN3,
PRD_DETAILS.EX_GST_ITEM_COST,
PRD_DETAILS.FRANCHISE_CODE,
PRD_DETAILS.GST_ITEM_COST,
PRD_DETAILS.ITEM_COST,
PRD_DETAILS.NOTES,
PRD_DETAILS.ORD_QTY,
PRD_DETAILS.PRD_CLASS,
PRD_DETAILS.PRD_CODE,
PRD_DETAILS.PRD_DESC,
PRD_DETAILS.PRD_SIZE,
PRD_DETAILS.PRD_STATUS,
PRD_DETAILS.RRP,
PRD_DETAILS.SEQ,
PRD_DETAILS.TESTER,
PRD_DETAILS.TERID
FROM PRD_DETAILS
WHERE PRD_DETAILS.PRD_CODE LIKE '%1%' AND
(PRD_DETAILS.FRANCHISE_CODE >= 0 AND
PRD_DETAILS.FRANCHISE_CODE <= 999999999) AND PRD_DETAILS.TERID = 31
ORDER BY PRD_CODE
// The following statement is SUCCESSFUL and it returns only 143 records
SELECT PRD_DETAILS.APN1,
PRD_DETAILS.APN2,
PRD_DETAILS.APN3,
PRD_DETAILS.EX_GST_ITEM_COST,
PRD_DETAILS.FRANCHISE_CODE,
PRD_DETAILS.GST_ITEM_COST,
PRD_DETAILS.ITEM_COST,
PRD_DETAILS.NOTES,
PRD_DETAILS.ORD_QTY,
PRD_DETAILS.PRD_CLASS,
PRD_DETAILS.PRD_CODE,
PRD_DETAILS.PRD_DESC,
PRD_DETAILS.PRD_SIZE,
PRD_DETAILS.PRD_STATUS,
PRD_DETAILS.RRP,
PRD_DETAILS.SEQ,
PRD_DETAILS.TESTER,
PRD_DETAILS.TERID
FROM PRD_DETAILS
WHERE PRD_DETAILS.PRD_CODE LIKE '%a%' AND
(PRD_DETAILS.FRANCHISE_CODE >= 0 AND
PRD_DETAILS.FRANCHISE_CODE <= 999999999) AND PRD_DETAILS.TERID = 31
ORDER BY PRD_CODE
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
