| SQLite Overview |
 |
2025-12-05 |
 |
 |
41 |
 |
|
synchronous
This is perhaps the most import option you can control as it has significant impact on both the performance and
data integrity of your SQLite database.
NORMAL
Default setting, which offers a fair blend between performance and data integrity
NONE
Performance oriented setting, which increases performance but increases danger of data-loss due to power, application failure.
FULL
In this mode there is virtually no change any data would be lost, however this results in significantly diminished performance.
<?php
$db = new SQLiteDatabase("./db.sqlite");
// PRAGMA parameters are set via sqlite_query()
$db->query("PRAGMA default_synchronous=OFF");
?>
