Bureaucrats, editor, reviewer, Administrators
13,550
edits
Changes
Jump to navigation
Jump to search
once in when requested by the updating processdatabase users.
However, incremental indexing can be turned on for the textand attribute value index: With the [[Options#UPDINDEX|UPDINDEX]]option, text and attributesindex structures will incrementally be updated. This option must be activated turned on before creating a new databaseor running an optimizationon it. Note Please note thatincremental updates are not available forthe fulltext index and database statistics. {{Mark|Since Version 8.0}},the [[Options#AUTOOPTIMIZE|AUTOOPTIMIZE]]even with this optionis available, the update of the path and fulltext which recreates all outdated index willstructureshave to and statistics after a database update. This option should only be manually triggeredactivated for medium-sized databases.
→Updates
=Updates=
By default, index structures are discarded after an updateoperation.operationAs a result, and their maintenance is left queries will be executed more slowly. There aredifferent alternatives to the user.cope with this:
After the execution of update operations, the [[Commands#OPTIMIZE|OPTIMIZE]]
command or the [[Database Module#db:optimize|db:optimize]] function can be
called to rebuild the index structures.This way, multiple update operations will be performed faster,
as the database meta data is only updated and regenerated
=Changelog=
