Accelerate the reading and writing of SQLite

SQLite database on some machines will be read and write very slow problem, to a large extent, the journal file read and write. So the idea is not to use journal files, but to use memory as the data cache.

Examples of using QT are:

Qsqlquery ("PRAGMA page_size = 4096"); Qsqlquery ("PRAGMA cache_size = 16384"); Qsqlquery ("PRAGMA temp_store = MEMORY"); Qsqlquery ("PRAGMA Journal_mode = OFF"); Qsqlquery ("PRAGMA Locking_mode = EXCLUSIVE"); Qsqlquery ("PRAGMA synchronous = OFF");

Accelerate the reading and writing of SQLite