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 journal mode to WAL on the attached databases.
Here is some diagnostic output: Setting database 'DC2_DB_20110412' journal mode to WAL. sqlite3_exec('0x1f8f57a8','COMMIT',NULL,NULL,'cannot commit - no transaction is active') = SQLITE_ERROR sqlite3_exec('0x1f8f57a8','PRAGMA DC2_DB_20110412.JOURNAL_MODE=WAL',NULL,NULL,'cannot change into wal mode from within a transaction') = SQLITE_ERROR The two sqlite3_exec() statements are executed directly after each other. 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? I'm working with SQLite 3.7.3. Best regards, Jaco _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users