How to limit the number of results that are in cache

[kumarhanu]

I have turned on the cache at a report level by setting 'Use Local Cache' to 'Yes'. But I want to limit the number of results that are in cache/size of the cached memory/time interval. Are there any properties for doing this?

[blom0344]

CQEConfig.xml.sample in the server configuration folder allows for setting the query reuse to a certain value. The default is 5
Why do you want to change this?

[kumarhanu]

As per the documentation, default value of 'queryReuse' property in CQEConfig.xml is 5 which means cache up to 5 result sets per session.

But, looks it is not working as per my expectation. Running a report that is cache enabled by using 'Use Local cache'=Yes. My report has date input. I tried with different dates. Data is maintaining in cache even for more than 5 different date inputs.

For example, I ran report with 2/1/2013, 2/2/2013, 2/3/2013, 2/4/2013, 2/5/2013. All the data is in cache. But after running report with 2/6/2013, the data of 2/1/2013 should get deleted from the cache.

Please correct me if I am wrong.

Why I need property to control the cache data is, as per my observation, more than 10MB of .dmc file is getting created when running a report with huge data volume. When cache is enabled these files are not getting deleted until server restart. My concern is, if various reports are running with huge data volume, .dmc files (temporary file) gets created in huge size which is not acceptable. It would be good if we have control over limit the cache like no. of query results/size of the temp file/time interval.

Help me out in this regard. Thanks in advance.

[blom0344]

For query reuse I would expect that data is read from cache if the same request is issued. Your requests differ each time AFAIK understand. I'm not sure if the documentation sheds any light on this