CFCACHE or Query Caching for page optimization?

Posted on 2007-07-23
Medium Priority
Last Modified: 2007-07-26
hi, i've got a coldfusion application that outputs database information into a dynamic calendar.  i'm trying to optimize the performance so i was looking at using either cfcache or caching the query itself.

now the calendar uses a dynamic url to generate which month & year someone is looking at, so using either of the two options will result in multiple pages/queries being cached. keeping that in mind, which option is best to use? is one better suited for having multiple caches based on dynamic queries?
Question by:hunter-gatherer
1 Comment
LVL 14

Accepted Solution

Scott Bennett earned 1500 total points
ID: 19551581
I generaly only cache at the query level if I have a query in a template that gets <cfincluded> in multiple pages or gets called often and the values returned by the query are always going to be the same. For example if I have a table listing all the states in the US to populate a <cfselect> tag.

If you want to speed up the performance of a specific page that produces different output based on the value of its url parameters then I you want to use the cfcache method.

here is a good article on coldfusion caching:


Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

PROBLEM:  How to open a cfwindow or run a function on double click of a cfgrid row. One of my clients wanted to be able to double click on a row item to get more detailed information about a transaction and to be able to modify the line items i…
I spent nearly three days trying to figure out how incorporate OAuth in Coldfusion for the Eventful API. Hopefully, this article will allow Coldfusion Programmers to buzz through the API when they need to. Basically, what this script does is authori…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question