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