You can translate the question and the replies:

SSRS and Caching

I have created an SSRS report with parameters that the user inputs (using ? as parameter in the SQL). The derived view that the SSRS report is using has partial cache mode turned on with match exact queries only selected. It seems as if the report is not pulling from the cache because if i re-run the ssrs report with the exact same parameters, it takes the same amount of time to process. If I run the derived view with the same parametersin the denodo administration tool, the execution time is significantly less. Are there any suggestions or solutions you could point me to? Thank you!
user
26-02-2019 11:19:32 -0500
code

1 Answer

Hi, I was successfully able to use partial cache with the ‘match exact query only’ selected to retrieve my data from cache for same query when executed repeatedly. I would validate the below scenarios to ensure the data is retrieved from cache: 1) You can use the [Denodo Monitor](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/monitoring_the_virtual_dataport_server/denodo_monitor/denodo_monitor) to check in the query logs whether the SSRS is generating a query identical to the one used for caching, thus satisfying the prerequisites of “match exact query only” partial cache. 2) Another cause for this behaviour could be a result of the ‘Explicit Loads’ option being selected. In case of explicit load, it is expected for the data that is to be retrieved to be cached already through “Pre-loads”. If cache data is absent from the storage location, then it will retrieve data directly from the data source. You can refer to the section [Partial_Mode](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/cache_module/cache_modes/partial_mode) in the Virtual DataPort Administration Guide to get more details and the community question [Cache modes](https://community.denodo.com/answers/question/details?questionId=9060g000000fzEuAAI&Cache+modes) for more information on partial cache. Hope this helps!
Denodo Team
27-02-2019 05:02:03 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here