Improving Indexing Performance

Several customers have reported problems with the performance of the Content Engine's indexer web service in version 5.6. The web service can take a very long time (up to tens of seconds) to respond to requests.

If you experience this issue, the solution is to remove the SearchIndex_isTail_idx index from the SearchIndex table in your database. You can do this with the following command:

alter table SearchIndex drop index SearchIndex_isTail_idx;

If this change does not have the desired effect you can restore the index by re-running the database scripts included in your Content Engine distribution.