Search Optimization


Previous page Next page  Documentation Home Print this Topic

KnowledgeTree Overview > Search Overview > Search Optimization

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.

How do I optimize the Indexer?

 

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.

 

Techniques that improve performance

1.Group database fields closer to one another
2.Group the full text fields closer to one another
3.Minimize complex expressions

 

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")

 

 

© 2008 KnowledgeTree Inc.
Creative Commons License
This work is licensed under a
Creative Commons Attribution 3.0 License.