iConsole Search Definition Reference Guide › Performance Tips

Performance Tips

To make your searches as efficient as possible, you must understand how results are retrieved by the iConsole. When a search is requested, the sequence of events is:

1. The database builds a set of results to satisfy the query.
2. The iConsole infrastructure retrieves results one row at a time into a cache.
3. The iConsole service limits the maximum number of rows that can be stored in the cache to prevent resources being exhausted (defaults to 1000).
4. The browser requests a page of results (25) from the iConsole service's cache.

This section contains the following topics:

Tips for SPs and Search Definitions