Disable Query Cache

We can disable the Query Cache for  an entire application , or a particular Session or a particular answer/request.

Disable Query Cache for the Entire Application :

To disable the query cache for the entire application, you must set to the ENABLE cache parameter the value NO in the file NQSConfig.INI.

Disable Query Cache for for one session :

To disable query cache for one session, you have to set the below mentioned session system variables with the value 1:

• DISABLE_CACHE_HIT
• DISABLE_CACHE_SEED

Disable Query Cache for for one Request/Answer:

To disable query cache for one Request/Answers, you have to set the below mentioned request variables  with the value 1:

• DISABLE_CACHE_HIT
• DISABLE_CACHE_SEED

Eg: If you want to disable query cache for a particular request, then do the following things.

1. First add the required number of columns in criteria tab of Answers.

2. Then click on Advanced tab.

3. Find the Prefix Box and write the following statements.

SET VARIABLE DISABLE_CACHE_SEED=1,DISABLE_CACHE_HIT=1;

When the value of the request variable DISABLE_CACHE_SEED is 1 for any request, then the OBI Server does not store the result of that request in Query Cache.

When the value of the request variable DISABLE_CACHE_HIT is 1 for any request, then the OBI Server does not look into Query Cache. So, even the Query Cache contains result of the similar request, BI Server will not look into it, and it will get the result from back end Database.