Caching

The Caching Settings page of the Administrator contains configuration options that you can set or enable to cache templates, queries, and data sources. They can significantly affect server performance. Use the following table to learn more about the options

Option

Description

Template cache size: [n] kilobytes
Enable this option to limit the memory reserved for template caching. For best performance, set the value to the total number of kilobytes of all your active ColdFusion pages.

Trusted cache
Enable this option if you want ColdFusion Server to use cached templates without checking whether they changed. For templates that are not updated frequently, using this option minimizes file system overhead.

Limit cached database connection inactive time to [n] minutes
Enable this option by entering a value to limit the time that ColdFusion Server allows a cached database connection to remain inactive before disconnecting. Enter 0 if inactive connections should be maintained as long as ColdFusion Server is executing. If the option to maintain database connections is not enabled in the Edit Data Source page for an individual data source, the option is ignored. For more information, see "Adding Data Sources for ColdFusion".

Limit the maximum number of cached queries on the server to [n] queries
Enable this option by entering a value to limit the maximum number of cached queries that the server maintains. Cached queries allow retrieval of result sets from memory rather than through a database transaction. Because queries reside in memory, and query result set sizes differ, you must provide a limit for the number of cached queries.

:

Installing and Configuring ColdFusion Server
Basic ColdFusion Server Administration

Option	Description
Template cache size: [n] kilobytes	Enable this option to limit the memory reserved for template caching. For best performance, set the value to the total number of kilobytes of all your active ColdFusion pages.
Trusted cache	Enable this option if you want ColdFusion Server to use cached templates without checking whether they changed. For templates that are not updated frequently, using this option minimizes file system overhead.
Limit cached database connection inactive time to [n] minutes	Enable this option by entering a value to limit the time that ColdFusion Server allows a cached database connection to remain inactive before disconnecting. Enter 0 if inactive connections should be maintained as long as ColdFusion Server is executing. If the option to maintain database connections is not enabled in the Edit Data Source page for an individual data source, the option is ignored. For more information, see "Adding Data Sources for ColdFusion".
Limit the maximum number of cached queries on the server to [n] queries	Enable this option by entering a value to limit the maximum number of cached queries that the server maintains. Cached queries allow retrieval of result sets from memory rather than through a database transaction. Because queries reside in memory, and query result set sizes differ, you must provide a limit for the number of cached queries.