The ColdFusion Administrator allows a user to set a limit to the number of queries that are cached. This value is set on the Caching page of the ColdFusion Administrator by providing a numeric value in the field "Maximum number of cached queries n". The default value for the setting is "100". Entering a "0" in this field is the same as defining the maximum number of cached queries as "unlimited". In large applications where many queries are run, this could cause problems with performance.
Behavior of Cached Queries When Maximum Number is Set to 0