Page 1 of 1

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

Posted: 08 Sep 2020, 10:50
by tkinte
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

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

Posted: 09 Sep 2020, 06:45
by JohnM
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

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

Posted: 09 Sep 2020, 20:56
by tkinte
Hi John.

Thank you .

The future will be brighter... looking forward.

Best regards,

Tshitshi

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

Posted: 13 Oct 2020, 15:27
by JohnM
Hi,

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

Regards

John

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

Posted: 13 Oct 2020, 16:04
by tkinte
Hi John.
Thank you. Great!

Best regards.

Tshitshi