AutoComplete indexes

As with any search tool, indexes are an important part of the AutoComplete service. The basic purpose of an index is to speed up searches by storing a list of values in an accessible location. Specifically, the AutoComplete service indexes the properties for which AutoComplete is enabled. To build an index, the service gets all values of the selected property from the database and stores them on the local machine. The service can then complete a search using the values in the index, without having to hit the database.

By default, the AutoComplete indexes are stored in a folder called IndexSearch, which you can find in the bin folder of your AutoComplete installation. (If you’re using the hosted AutoComplete functionality, IndexSearch is in the Infor Public Sector application folder.) In the IndexSearch folder, you’ll see a subfolder for each component for which AutoComplete is enabled.

How and when the indexes are created and updated is controlled by the Index Behavior attribute in the AutoComplete configuration. There are three different options:

• CreateAndRefresh: The service creates indexes and updates them at the interval specified in the Refresh Rate attribute.
• Recreate: Recreates indexes, but doesn’t refresh them.
• Load: The service only loads existing indexes, creating them if they don’t exist.

The Refresh Rate attribute defines the interval at which indexes are updated.

If the index behavior is Recreate or Load, you can manually refresh an index by deleting the index folder from IndexSearch. The AutoComplete service will then recreate the index, using the current values in the database.

Also note that if the index behavior is CreateAndRefresh, any new values added to the database won’t be displayed in the AutoComplete results until the indexes are updated. If you want to see new values right away, you can manually refresh the index by deleting the index folder.