ColdFusion 4 introduced query caching, a mechanism by which queries may be reused to prevent unnecessary database access. But to prevent this feature from chewing up uncontrolled amounts of memory, it was limited to 100 queries only. Need to cache more queries than that? Actually, despite what the notes in the ColdFusion Administrator say, you can. As long as you are running CF4.5.1 or later you can cache as many queries as you want, just go in to the Administrator and change that value. (Applies to: ColdFusion 4.5.1 (or later))

Leave a Reply