$swDbaHandler
The revisions of Sofawiki are flat file and never changed.
However, for some index files and query cache, databases are used as key-value-store. Which database is used depends on the $swDbaHandler setting.
- persistance (default): The data is saved as serialized PHP object. Works for small sites (less than 20 000 revisions). Must be used if neither Sqlite3 nor dba_handlers are installed with PHP.
- sqlite3: The data is saved into a sqlite3 database file. Best performance for bigger sites (more than 100 000 revisions), preferred version, if sqlite3 is installed with PHP.
- db4': Berkeley database. Good performance on middle sized sites (-20 000 to 100 000 revisions). Needs dba_handlers installed with PHP.
The default value is set in api.php.
Set your value in site/configuration.php
If you change the setting on a running system, reset all indexes in Special:Indexes