At 04:18 PM 1/16/03 -0500, you wrote: >Could someone point me to what exactly is a cached query.
It's kind of what it says. The record set is stored in memory for the specified time. As long as it hasn't expired, subsequent requests are pulled from memory. On SMARTERyellowpages.com for example, I cache a lot of queries for 5 minutes so a user paging "next 50" pulls data from memory - NOT the database. > Like once a use >cachedwithin is it pulling the exact data that it did before, or is it going >back to the datasource a little faster? What about if I am passing >parameters to it, does it have to cache each instance of that query? It caches each instance of the same query when parameters vary. I've heard, that it will even chache an instance with the same parameters if the second query has identical functionality but is laid out a bit different. (Don't know if this is an urban legend.) best, paul >Robert Everland III >Web Developer Extraordinaire >Dixon Ticonderoga Company >http://www.dixonusa.com > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
