Prefetch Cache

Prefetch Cache

Prefetch Caches

  • There is a prefetch cache for each database
  • Each cache entry is populated from the databases at Sitecore startup
  • The items to cache are specified in the /app_config/prefetch config files
  • Cached items includes those in the config file for the specific database (for instance master.config) and the common.config file
  • Entries include all field values for all versions of the item and information about the parent and children of the item
  • The <childLimit> element defines a limit to the number of children to include in the prefetch cache

Configuration Settings

Web.config

<configuration>
   <databases>
      <database>
         <dataProviders hint="list:AddDataProvider">
          <dataProvider ref="dataProviders/main" param1="$(id)">
            <prefetch hint="raw:AddPrefetch">
              <sc.include file="/App_Config/Prefetch/Common.config" />
              <sc.include file="/App_Config/Prefetch/Core.config" />
            </prefetch>
          </dataProvider>
        </dataProviders>

 

Common.config

<configuration> 
    <cacheSize>20MB</cacheSize>
    <childlimit>100</childlimit> 
</configuration>


Sources