Bureaucrats, editor, reviewer, Administrators
13,550
edits
Changes
Jump to navigation
Jump to search
→Updates
* After the execution of one or more update operations, the <code>[[Commands#OPTIMIZE|OPTIMIZE]]</code> command or the [[Database Module#db:optimize|db:optimize]] function can be called to rebuild the index structures.
* The <code>[[Options#UPDINDEX|UPDINDEX]]</code> option can be activated before creating or optimizing the database. As a result, the text , attribute and attribute index structures token indexes will be incrementally updated after each database update. Please note that incremental updates are not available for the token index, full-text index, and database statistics. This is also explains why the up-to-date flag, which is e.g. displayed via <code>[[Commands#INFO DB|INFO DB]]</code> or [[Database_Module#db:info|db:info]], will be set to {{Code|false}} until the database will be optimized again.
* The <code>[[Options#AUTOOPTIMIZE|AUTOOPTIMIZE]]</code> option can be enabled before creating or optimizing the database. All outdated index structures and statistics will then be recreated after each database update. This option should only be used for small and medium-sized databases.
