Optimizing CBR query performance

You can optimize the performance of a CBR query by controlling the order of the two main constituent searches for the query. These two searches are the database search and the full-text search.

About this task

Database-first execution is more efficient in the following circumstances:

  • The number of database search hits is small; in the typical case, this number is less than a few hundred.
    Note: Too many database hits in a database-first search can cause high CPU utilization in CSS servers.
  • The number of full-text search hits is large; in the typical case, this number is more than several thousand.

For your object store, what constitutes a small and large number of search hits can vary from the typical case.

Procedure

To change the query optimization settings for an object store:

  1. Access the CBR query optimization properties in the administration console:
    1. In the domain navigation pane, click the object store.
    2. In the object store navigation pane, click the name of the object store (the top-level item).
    3. In the details pane, click the Query tab.
  2. Change the values for the properties in the CBR Query Optimization section as appropriate.
  3. Save your changes.