Re: [sqlite] can't drop a temp table because database table is locked

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

Re: [sqlite] can't drop a temp table because database table is locked

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? Is there

Re: [sqlite] can't drop a temp table because database table is locked

On 03/07/2018 07:44 PM, Nir wrote: Hi, I tried to change a couple of my select queries to precompiled, meaning I prepare them once and bind an int/string each time for performance gain. I only reset and clear bindings before binding and executing my query and I only finalize the statement when m