6.3 How real-time searching works, how to disable

The real-time searching works by maintaining a list of records that have changed, and then looking at those records to resolve the query. This requires some extra effort to read and check each of the new records. The effort to search a single record is much less than the effort required to update the index. With thousands of new records, or after thousands of searches the balance might change.

As an aid to load management it is possible to disable the searching of the new records. This might be used if you are inserting a very large batch of records while searches occur, and you don't care about the real-time nature of the update. The was to disable the real-time searching is: set ignorenewlist=1; and you would reenable it by setting back to 0.

Back: When to update manually

Next: Performance and Installation Notes