Loop for 61153 records start rowIndex at 0
sqlite3_prepare_v2 ("SELECT id, blobdata FROM Table30KB Where id =
rowIndex")
sqlite3_step()
sqlite3_finialize()
End
Make that
sqlite3_prepare_v2 ("SELECT id, blobdata FROM Table30KB")
Do
sqlite3_step() // handle errors somehow (busy, ...)
Until SQLITE_DONE
sqlite3_finalize()
You have primary key index, don't you? So you don't need ORDER BY.
Now 34 rows seem really few to cause memory shortage. Can you show the
relevant part of your code?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
