Caching with CFQUERY? To be honest I rarely use CFQUERY now apart from QoQ so I am a tad rusty on its ins and outs ;-)
-----Original Message----- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: 21 January 2005 13:51 To: CF-Talk Subject: RE: Stored Proc Question Good point. But you can't use query caching without placing in application or session scope and still use cfqueryparam -----Original Message----- From: Robertson-Ravo, Neil (RX) In some cases yes but in reality if you are using query caching with cfquery it can be just as fast. For simple selects you will see negligible difference in as far as the parsing is concerned but there is a hell of a lot of other things to consider with using an SP over CFQUERY which will be faster such as use of memory etc. It is not all about how fast you get results back. -----Original Message----- From: Andy Ousterhout I thought that even with simple queries that Stored Procs where much faster? I tried this on a couple of other SELECTS and got noticable improvement. By the way, I always use CFQUERRPARAM. Andy -----Original Message----- From: Jochem van Dieten Andy Ousterhout wrote: > Here is the proc that I am using. You suggest either 2 separate queries or > 2 procs? Why are you using a stored procedure? This appears to be a simple SELECT that would be equally good with cfqueryparam. If there are no urgent pattern / encapsulation reasons I would probably just use 2 queries in the CF code. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191342 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
