Optimizing Indexing for Search

Search optimization is performed through a scheduled task. For best performance, the Indexer should be regularly optimized  - typically once a day around midnight, or weekly, depending on the frequency of updates to the index.

Note: This option is not relevant for KnowledgeTreeLive - the hosted, SaaS version of KnowledgeTree Commercial on-premise. View details on the KnowledgeTree Wiki.

Note: Complex search expressions may cause performance issues, typically when the

expression evaluator has to determine which sub-expressions should run on the database

and which sub-expressions should run on the Document Indexer.

In this case, the expression evaluator search engine attempts to evaluate

all the sub-expressions that are possible on each system without breaking the

meaning of the expression. Ideally each system should be queried as little as

possible per query.

To improve performance ...

Example:

The following expression ...

(DocumentText contains "hello World") and (Filesize <= "100") and (DiscussionText contains "world") and (title contains "hello")

... is best rephrased as:

(DocumentText contains "hello World" and DiscussionText contains "world") and (Title contains "hello" and Filesize <= "100")