CFCACHE or Query Caching for page optimization?

Posted on 2007-07-23
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

    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

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    This article  is about submitting  form through  ColdFusion.Ajax.submitForm to the action page and send a response back in JSON format which later can be decoded using ColdFusion.JSON.decode. By this way you can avoid the usual page refresh for subm…
    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…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    733 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now