Slow queries

Slow queries can be caused by lack of resources, improperly tuned systems, and complex queries.

To decrease the time for a query to complete, consider the following actions:
  • Reduce the number of full-text indexes in your search.
  • Use the index partitioning feature to reduce the number of indexes that are searched.
  • Reduce the complexity of your query; use fewer search criteria.

    A query that has many hits requires more time. For example, a complex query with many search criteria that has 500,000 hits in multiple full-text indexes can run for more than an hour.

  • Tune CPE to optimize CBR search.
  • Increase the processing and memory resources of the CSS servers.
  • Increase the number of CSS servers.
  • Tune your storage and network resources.
Note: CBR query response times vary also due to factors over which a user has little or no control. An index that was recently searched and is cached yields a quicker response. An index that is on remote or cloud storage yields a slower search.