Hi,
Before I start diving into the sqlite3 code, I was wondering if anyone had this
sort of problem before and could possibly point out to me where I might find
the problem.
I am running 3.7.9 on a embedded project using a database with one table
(structured (integer id, blobdata BLOB). Now the id goes from 0 to 61153 and
the blob data is off size 30K roughly.
When I do a loop of the following for every row in the table:
Loop for 61153 records start rowIndex at 0
sqlite3_prepare_v2 ("SELECT id, blobdata FROM Table30KB Where id = rowIndex")
sqlite3_step()
sqlite3_finialize()
End
The code will start to return 7 ( for NOMEM) after requesting the 34th row. Why
would it be running out of memory if I've completed the steps as per the sqlite
website for properly forming prepare, step then finalize?
Regards
Stuart T
________________________________
BitWise Ltd - Crescent House, Carnegie Campus, Dunfermline, KY11 8GR, United
Kingdom
tel: +44 (0)1383 625151 - mob:
web: BitWise Group <http://www.bitwisegroup.com>
This e-mail may be confidential and privileged. Do not open it if you are in
any doubt that you are the intended recipient. You must scan this e-mail and
any attachments for the presence of viruses or any other unwelcome content.
This e-mail must be read in conjunction with the important legal notice at
BitWise Group/Legal <http://www.bitwisegroup.com/legal>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
