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:
ChildProperties
ControlProperty
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:
Sign up for our free beginner training. Boost your credentials through advanced courses and certification. Register for Sitefinity training and certification.
To submit feedback, please update your cookie settings and allow the usage of Functional cookies.
Your feedback about this content is important