Siebel Analytics Performance Tuning Guide > Siebel Analytics >

Enable Query Caching

Decision support queries are usually complex and process a large number of rows. The fastest way to process such a query is to process the query once, save its result set in a cache, and then use the cached results to answer subsequent queries. The cached results can also be used to answer queries that request a logical subset of the cached results.

That is the basic idea of query caching, a technique Siebel Analytics uses which can dramatically improve query response time as well as reduce the overall demand for computing resources. Moreover, the user benefits without any knowledge of the underlying machinery.

Siebel Analytics is shipped with query caching enabled. You do need to configure the cache storage and decide on a strategy for flushing the outdated entries. The parameters that control query caching are located in the NQSConfig.ini file, which are described in the Siebel Analytics Installation and Configuration Guide.


 Siebel Analytics Performance Tuning Guide 
 Published: 18 April 2003