Hi,
We've introduced the ability to precache data. If you look in EA Support > Essential Viewer > Report you will see a Data_Set_API folder. Within there you will see some reports, these point to files that are called in views via APIs - we are using these in some heavy reports to speed things up. You can see some examples in our github, for example,
https://github.com/essentialproject/ess ... cation/api you will see some files.
and an example where we use these is here
https://github.com/essentialproject/ess ... hboard.xsl, if you look at the top of the code you'll see reportAPIs defined, if you trace the variables through you'll see how it all hangs together. Note we've rewritten the IT Asset again in 6.11 to perform much faster.
If you look back at the reports in the Data_Set_API folder there is a checkbox for precache. When you check this box it caches the results of the report as a JSON structure when you publish - it does this in the background. Once the report has finished processing then any view using that reportAPI will use the cached version, or if that doesn't exist, run the query as normal. It allows us to improve performance significantly for some views. We'll provide more detail when we do the 6.11 release in a few weeks time.
Hope that helps