Manual:Sqlite.php

sqlite.php is a maintenance script for tasks specific to SQLite backend.

Currently, two options are supported:


 * --vacuum: Executes VACUUM command that compacts the database and improves its performance.

Example: $ php sqlite.php --vacuum VACUUM: Database size was 46995456 bytes, now 37796864 (19.6% reduction).


 * --integrity: Performs integrity check of the database. If no error is detected, a single "ok" will be displayed, otherwise the script will show up to 100 errors.

Example: $ php sqlite.php --integrity Performing database integrity checks: ok

Both options can be used at the same time.