Bureaucrats, editor, reviewer, Administrators
13,550
edits
Changes
Jump to navigation
Jump to search
→Updates
Updates in BaseX are generally very fast, because the index structures will be invalidated by updates. As a result, subsequent queries may be executed more slowly than before the update. There are different alternatives to cope with this:
* After the execution of one or more update operations, the {{Command|OPTIMIZE}} command or the [[{{Function|Database Module#db:optimize|db:optimize]] }} function can be called to rebuild the index structures.* The {{Option|UPDINDEX}} option can be activated before creating or optimizing the database. As a result, the text, attribute and token indexes will be incrementally updated after each database update. Please note that incremental updates are not available for the full-text index and database statistics. This is also explains why the up-to-date flag, which is e.g. displayed via {{Command|INFO DB}} or [[Database_Module#db:info{{Function|Database|db:info]]}}, will be set to {{Code|false}} until the database will be optimized again.
* The {{Option|AUTOOPTIMIZE}} 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.
