Attempts to optimise the database. All schemas are optimised.
To achieve the best long-term query performance without the need to
do a detailed engineering analysis of the application schema and SQL,
it is recommended that applications run PRAGMA optimize (with no
arguments) just before closing each database connection.
Long-running applications might also benefit from setting a timer to
run PRAGMA optimize every few hours.
The function returns the following error codes:
E_DB_PREPARE if statement preparation failed.
E_DB_STEP if step execution failed or no write permission.
Nodes of different colours represent the following:
Solid arrows point from a procedure to one which it calls. Dashed
arrows point from an interface to procedures which implement that interface.
This could include the module procedures in a generic interface or the
implementation in a submodule of an interface in a parent module.
Nodes of different colours represent the following:
Solid arrows point from a procedure to one which it calls. Dashed
arrows point from an interface to procedures which implement that interface.
This could include the module procedures in a generic interface or the
implementation in a submodule of an interface in a parent module.