I've heard of someone that looks at the execution time of a query, when it exceedes a certain standard the query's will be cached (at a busy time or something like that). I'ts a way to cache it when you need it
----- Original Message ----- From: "Carlisle, Eric" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 01, 2001 9:03 PM Subject: Caching Queries > An application I am working with is really bogging down a database server. > Can anybody point out an online resource to the pros/cons of caching > queries? Maybe I'm making this more than it is and it's not that > complicated. I'm just wondering if caching queries is an eventuality for > web applications that get a lot of traffic. > > Thanks, > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists