On 03/07/2018 11:40 PM, Nir wrote:
If I understand you correctly then all I need to do in order for the database
not to be locked would be to reset a prepared query right after I retrieve
the needed data. after reseting I can either drop a temp table or bind
another value to my prepared statement and rerun a query. right?


Right.
Is there any reason why we shouldn't reset and clear bindings right after we
are done with a query?
No reason at all. You should call sqlite3_reset() when you are done with a query - in some cases this is required to release database locks or to close an open read-transaction. I don't think there is any real reason to clear bound values though. Perhaps if they are very large and you want to free up memory sooner rather than later. In any case, no harm in doing so.

Dan.





--
Sent from: http://sqlite.1065341.n5.nabble.com/
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to