[sqlite] Controlling of check-pointing of WAL Dbs

2016-04-27 Thread Clemens Ladisch
Albert Banaszkiewicz wrote: > 1. Is there a way to control (i.e. disable) check-pointing happening at DB > closure ? The internal sqlite3WalClose() function does a checkpoint if it is able to get an exclusive lock (which implies that there are no other readers/ writers). So to prevent this

[sqlite] Controlling of check-pointing of WAL Dbs

2016-04-27 Thread Paul Sanderson
Can you kill the process rather than shut down your application? If the last connection doesn't get shut then the WAL will remain and will be in opened (but not played) when the DB is re-opened. Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786

[sqlite] Controlling of check-pointing of WAL Dbs

2016-04-27 Thread Albert Banaszkiewicz
Hello. I am new here, thus I would like to apologize in advance if the question I am going to rise was already asked in the past. I am using SQLite 3.11.1 (actually it is a NDS consortium customized version based on it). According to documentation, in case of WAL mode enabled databases, final

[sqlite] Controlling of check-pointing of WAL Dbs

2016-04-27 Thread Richard Hipp
On 4/27/16, Albert Banaszkiewicz wrote: > Hello. > > I am new here, thus I would like to apologize in advance if the question I > am going to rise was already asked in the past. > > I am using SQLite 3.11.1 (actually it is a NDS consortium customized version > based on it). > > According to