Scenario:
Has a c++ .exe application writes and reads a sqlite database every one second.
Has a php file writes and reads the same sqlite database every one second.
Problem:
Journal files are created locking the database, i want to turn off the journal files completely.
code:
on the c++ side this is the code to turn off the journal files:
sqlite3_exec(database, "PRAGMA synchronous=OFF", NULL, NULL, &errorMessage);
sqlite3_exec(database, "PRAGMA count_changes=OFF", NULL, NULL, &errorMessage);
sqlite3_exec(database, "PRAGMA journal_mode=OFF", NULL, NULL, &errorMessage);
sqlite3_exec(database, "PRAGMA temp_store=OFF", NULL, NULL, &errorMessage);
The above code is working fine, so if only the .exe application is accessing the db no journal files are created. But from the php side the journal files are being created.
So from the php pdo side what statements should i use to turn off the journal files?