Forums

Forums / General Discussions / What triggers the need for recompilation of pages?

What triggers the need for recompilation of pages?

5 posts, 1 answered
  1. Sivert Byfuglien
    Sivert Byfuglien avatar
    4 posts
    Registered:
    29 Sep 2021
    21 Jun 2022
    Link to this post
    Hi,

    I'm noticing that pages with TPC forms on them have slow load times if they have not been visited for some time (>12h or something). I assume this is because the pages are getting recycled and need to be compiled again. However, this is not happening with standard Sitefinity pages and they load instantly. What is the explanation behind this and is there anything we can do to extend the time period until recompilation is required? 

    Also, is there any more documentation on what the advanced cache invalidation plugin does?

    Thanks for any input
    - Sivert
  2. Vladyslav Makar
    Vladyslav Makar avatar
    20 posts
    Registered:
    16 Dec 2020
    23 Jun 2022 in reply to Sivert Byfuglien
    Link to this post
    Greetings Sivert,

    Thanks for reaching us here!

    I would recommend you trying switching the Metadata Sliding Cache Expiry (hours) from 12 to 24. You can do it under Settings -> The Portal Connector Configuration -> Metadata Settings.

    Here is the documentation for the cache invalidation that I was able to find for you:

     https://www.crmportalconnector.com/developer-network/documentation/setup-portal-connector/setup/enable-the-advanced-cache-invalidation-plugin-optional

    https://www.crmportalconnector.com/developer-network/documentation/setup-portal-connector/setup/disable-the-cache-invalidation-plugin

    Kindly, let me know if that was helpful for you or if you would still need help!

    Vlad 
    Last modified on 14 Oct 2022 14:10 by Omar S
  3. Sivert Byfuglien
    Sivert Byfuglien avatar
    4 posts
    Registered:
    29 Sep 2021
    24 Jun 2022 in reply to Vladyslav Makar
    Link to this post
    Hi, 

    Thanks for the response. The Metadata Sliding Cache Expiry setting was what I was looking for it seems. 

    I appreciate the provided documentation, however I was looking for any additional explanation of what the plugin or CacheData property does. The documentation doesn't really explain what the implications of using the property and enabling the plugins are. What data is getting cached and on what grounds is cache invalidated? 

    Regards,
    Sivert
    Last modified on 24 Jun 2022 11:06 by Sivert Byfuglien
  4. Avi haa
    Avi haa avatar
    2 posts
    Registered:
    31 Aug 2022
    31 Aug 2022
    Link to this post
    If a database undergoes significant changes to its data or structure, recompiling a procedure updates and optimizes the procedure's query plan for those changes. This can improve the procedure's processing performance.
  5. Omar S
    Omar S avatar
    51 posts
    Registered:
    04 Jul 2019
    Answered
    14 Oct 2022 in reply to Sivert Byfuglien
    Link to this post
    Hello Sivert 
    CacheData is a relatively new feature (within the past year as of this post) and by setting it to true, it prevents making queries to the CRM for a certain period (depending on whether you have an absolute cache or a sliding cache).

    As of TPC 6.0, it is available for TPC Grids, List View, Lookups and all Form Configurations. In order to use it though, you need to enable the TPC AdvancedCacheInvalidation plugin on the CRM using XRM Tool Box.

    More information can be found at the beginning of this video: The Portal Connector 6.0 Release

    Last modified on 18 Oct 2022 22:10 by Omar S
5 posts, 1 answered