Sitefinity CMS has optimizations for constructing the database queries in the following scenarios:
Unnecessary database calls could lead to potential N+1 problems while trying to construct the ASP controls of the requested page. Sitefinity CMS resolves this issue by the introduction of a mechanism, which caches calculated metadata about hierarchical persistent objects (ChildProperties) in their parent (ControlProperty). The metadata information is calculated in the following scenarios:
Using this caching mechanism the system is slowly optimizing itself every time an editor makes changes to the pages.
In cases, where you would like to manually optimize and force recalculation of all the metadata, you can launch a scheduled task to do this for you. This is convenient for large systems - an example scenario is when templates that are used by a large amount of pages are rarely changed and therefore the metadata is not calculated. To do this you can use the following code sample:
Back To Top