Has anyone tested simple cached queries with CFQUERY against the performance of sp_executesql and SQL statement strings? Functionally it's exactly the same as cfquery in that variables are replaced with values... however, the DB does the work and the CF server simply issues directives and receives results.
The gotcha here is that it's (afaik) a SQL Server only solution... and that sux. Well, at least it does if it's any better. This is really interesting, because on my last major I completely converted to stored procs and views because I had some conditional datasets (i.e. is this user a staffmember or a client? find out, return the right data) that I was able to accomplish with an sproc whereas I'd have had to have CF issue at least 2, possibly 3-5 cfquery routines. Also, with sprocs and views I was able to completely abstract the application from the specifics of the DB schema... which I found to be very cool. I've always heard "CF is an application server, compartmentalize functionality and let the DB do what it does best and let CF handle the smallest amount of data it needs to do the job." Has this changed, or is it just much less concrete than I've been thinking of it in the past? On Fri, 21 Jan 2005 15:42:15 +0100, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > Andy Ousterhout wrote: > > I thought that even with simple queries that Stored Procs where much faster? > > That is not my experience. YMMV > > Jochem > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:191358 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
