[6.10.4 EUP] Pre-Caching Report API Slot ? What does it mean ?

Post Reply
User avatar
tkinte
Posts: 145
Joined: 18 Nov 2014, 08:24
Location: https://www.linkedin.com/in/tshitshi-kia-ntoni
Contact:

Hi.

When applying the 6.10.4 eup, i see

Code: Select all

Applying pack: Pre-Caching Report API Slot
Meta-model extension to support pre-caching of Report APIs
What does it mean ? No more need to configure the former cache ?

Best regards,

Tshitshi
JohnM
Posts: 478
Joined: 17 Feb 2009, 20:19

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
User avatar
tkinte
Posts: 145
Joined: 18 Nov 2014, 08:24
Location: https://www.linkedin.com/in/tshitshi-kia-ntoni
Contact:

Hi John.

Thank you .

The future will be brighter... looking forward.

Best regards,

Tshitshi
JohnM
Posts: 478
Joined: 17 Feb 2009, 20:19

Hi,

This is released now, for more information on the caching see this page https://www.enterprise-architecture.org ... lainer.php

Regards

John
User avatar
tkinte
Posts: 145
Joined: 18 Nov 2014, 08:24
Location: https://www.linkedin.com/in/tshitshi-kia-ntoni
Contact:

Hi John.
Thank you. Great!

Best regards.

Tshitshi
Post Reply