Caching

default

markdown

#Caching in Izenda

[[_TOC_]]

##Question

What kinds of caching does izenda.come? Can I update the cache?

##Answer

Izenda caches your queries, reports and schema information automatically per browser session. By default, caching is stored in memory and in the temp folder of the server that Izenda is hosted on.

Since Izenda 6.8.0.7, Izenda checks the Database Schema cache available to it against the VisibleDataSources array set in InitializeReporting() to make sure it has every data sources it needs, and will update the cache accordingly, if necessary.  This eliminates the need for AdHocSettings.PerUserCaching = true, which tells Izenda to store a separate copy of the database schema cache for each user in session.

Here is a list of the caching methods - and links to their individual articles - that are available in case you wish to manipulate the different caches, although generally the caches will self-update as needed:

###FilteredListReports

The [[AdHocConfig.FilteredListReports|http://wiki.izenda.com/FAQ/FilteredListReports]] method will return a list of reports that are guaranteed to be available to the current user. This means that the reports were found in storage, identified as available to the current user, successfully loaded from storage into cache, and ready for use.

###InvalidateFilteredCaches

The AdHocConfig.InvalidateFilteredCaches() method will clean up the results cached in the FilteredListReports method and can be called manually if needed. For instance, when the XML definitions of one or more reports change outside the environment.

###DataCacheInterval

[[AdHocSettings.DataCacheInterval|http://wiki.izenda.com/API/CodeSamples/DataCacheInterval]] sets the number of minutes between cache refreshes for FUSION (HTML) cache. Example: ``AdHocSettings.DataCacheInterval = 60 * 24 * 30;``

###InvalidateSchemaCache

The AdHocContext.Driver.InvalidateSchemaCache() method will update the schema for database changes on, all filtered report lists, queries to the database that were cached, cached HTML results of reports, and cached XML report definitions.

###InvalidateSchemaOnNew

[[AdHocSettings.InvalidateSchemaOnNew|http://wiki.izenda.com/API/CodeSamples/InvalidateSchemaOnNew]] is a Boolean which tells the system if it should should update the schema for database changes when a new report is being created. This is useful for environments where the database is constantly changing.

###CacheQueries

The [[AdHocSettings.CacheQueries|http://wiki.izenda.com/API/CodeSamples/CacheQueries]] setting is a Boolean (default is true) which tells Izenda whether or not the result set of a particular query should be cached.  You can manipulate how long the query is cached using AdHocContext.Driver.QueryCachingTime (see the CacheQueries article for more).

###CacheReports

The [[AdHocSettings.CacheReports|http://wiki.izenda.com/API/CodeSamples/CacheReports]] setting is Boolean (default = true) which gets or sets the value indicating whether all loaded reports should be cached.

###PerUserCaching

The [[AdHocSettings.PerUserCaching|http://wiki.izenda.com/API/CodeSamples/PerUserCaching]] setting is another Boolean value (default = false) which determines whether or not a user-specific DatabaseSchema object is cached in the session for each user.

###CacheSchema

[[AdHocSettings.CacheSchema|http://wiki.izenda.com/API/CodeSamples/CacheSchema]] (default = true) is a Boolean setting which tells Izenda whether or not the DatabaseSchema object should be cached. By default, it is cached in application memory and on the filesystem. The cache file name is generated using the database connection string and [[VisibleDataSources|API/CodeSamples/VisibleDataSources]].

**Note:** Use PerUserCaching to store the schema in session memory. This will also generate a folder per user on the server using the database connection string, [[VisibleDataSources|API/CodeSamples/VisibleDataSources]], [[CurrentUserName|API/CodeSamples/CurrentUserName]], and [[CurrentUserTenantId|API/CodeSamples/CurrentUserTenantId]] as the hash for the cache folder name.

###SchemaCacheTimeout

[[AdHocSettings.SchemaCacheTimeout|API/CodeSamples/SchemaCacheTimeout]] (default 1 day) is a TimeSpan setting that controls how long the database schema cache files will remain on the server before data should be re-obtained from the database.

###StoreImagesToCache

[[AdHocSettings.StoreImagesToCache|http://wiki.izenda.com/API/CodeSamples/StoreImagesToCache]] will inform Izenda whether to store images to the disk (true) or session (false) during the rendering of a report.

###CleanUpCache

The ``FusionCache.CleanUpCache`` method is part of the Izenda Fusion Driver suite and will clear all cached XML reports and dashboards.

###RefreshAllCachedReports

The ``FusionCache.RefreshAllCachedReports`` method can be called to update the cache of XML reports and dashboards based on whether the time period specified in the [[DataCacheInterval|/API/CodeSamples/DataCacheInterval]] setting has elapsed since the last time the report was cached. Unlike CleanUpCache above, this will NOT clear the cache. It will include changes made to all HTML reports for the current user. You can call this method yourself to update the cache based on your unique business logic (such as daily, during downtime hours).

###RefreshAllCachedDashboards

The ``FusionCache.RefreshAllCachedDashboards method will update the cache of XML dashboards, but not reports, based on whether the time period specified in the [[DataCacheInterval|/API/CodeSamples/DataCacheInterval]] setting has elapsed since the last time the dashboard was cached. This can be called based on your unique business logic.

###StaticSharedStorage

The StaticSharedStorage class is used to implement a completely static memory mode for the entire application. This must be set before any calls to the Izenda API if it is to be used. This means that it must come before even the license key declaration. Otherwise, Izenda will automatically store much of its configuration data in Session. Here is how to initialize the class:

```csharp
StaticSharedStorage.Activate(true);
```

###Limitations

Izenda Reports is a web application. Therefore, caching is susceptible to the client state. For example, do not have Izenda Reports running in separate windows or tabs of Internet Explorer. Otherwise, you could get the following behavior: by loading a report in one window and then loading a different report in another window, you may have unknowingly cached the second report, overriding the first. To properly enforce caching, only have a single instance of Izenda Reports running at a time per browser session. If you do open other browser windows and create/modify reports in that window, be sure you do not go back to the previous tab to continue modifying reports. Otherwise, you may see the newly cached report in your viewer instead of the one you were expecting to see.

###More Information
[[Izenda Caching Lifecycle|http://wiki.izenda.com/FAQ/Izenda Caching Lifecycle]]

Uploading file...

Header

Sidebar

![Izenda Logo](http://izenda.com/wp-content/uploads/2014/12/IzendaNewLogoBlueTR.png)

---

* [[Izenda 7 Series Documentation|https://www.izenda.com/docs/]]
* [[Release Notes]]
* [[Upgrade Best Practices|FAQ/Izenda-Update-Best-Practices]]
* [[FAQ]]
* [[Tutorials]]
* [[The Izenda API|/API/AdHocConfig]]
* [[The AdHocSettings class|/API/AdHocSettings]]
* [Developer Links and Guides](/Guides/Developer-Links-and-Guides)
* [[Known Issues]]

---

* <a href="http://www.izenda.com" rel="nofollow" target="_blank">Izenda Website</a>
* [Product Video](https://www.youtube.com/watch?v=X3-yWFq0w5A)
* <a href="http://www.izenda.com/blog" rel="nofollow" target="_blank">Izenda Blog</a>
* <a href="http://www.izenda.com/company/" rel="nofollow" target="_blank">About Us</a>
* <a href="http://www.izenda.com/contact-us/" rel="nofollow" target="_blank">Contact Us</a>

---
* [Guide To Report Design](/Guides/ReportDesign)
* [Making Custom Forms Video](http://www.youtube.com/watch?v=5b2axJlgdFs)

---

* [[Acknowledgements]]

Edit message:

Cancel

Editing Caching

Header

Sidebar