Re: [sqlite] Problem setting journal_mode=WAL

2011-04-12 Thread Pavel Ivanov
> If the 'COMMIT' reports that no transaction is active, why is the > JOURNAL_MODE pragma still complaining about it being within a transaction? > Am I missing something here? Probably you have some not finalized SELECT statements still active. To check that you can call sqlite3_close - it will

[sqlite] Problem setting journal_mode=WAL

2011-04-12 Thread Jaco Breitenbach
Dear experts, My application makes use of several data files attached to the SQLite database. Data files are attached on demand as they become necessary. I'm experimenting with the WAL journalling mode as a speed/performance optimisation. Unfortunately I'm having some difficulty setting the