> Lol-- Splitting hairs on technical verbiage are we? Not at all.
> Call it what you want, but I prefer to see my database as a > sort of "server-superhero" who's spider sense tingles when I > make more than "6 modifications to a temporary table" inside > my stored procs. You can prefer to see your database however you like. I (and Microsoft) have described how it actually is. The point of my bringing this up earlier is that there are plenty of cases where you might provide input values that are not optimal for your current execution plan, but that the database will use that execution plan nonetheless. Assuming that the database will simply take care of it for you may provide suboptimal results. > Hmm, all this talk of procs, prepared statements, and caching > reminds me of the debate over whether stored procs are better > than cfqeries using cfqueryparam. My last DBA swore up and > down that stored procs would ALWAYS perform better than > ColdFusion's "inline queries". > I never really knew enough to debate definitively on the > subject with him, but always assumed there wasn't really much > of a difference. Of course, there seems to be articles > supporting both points of view out there. In general, no, that's not true. Prior to the existence of CFQUERYPARAM, that would have been true much more often. Now, there's very little difference between the performance of a stored procedure and a prepared statement. However, you might choose to perform SQL operations in a stored procedure that you wouldn't attempt in a passthrough statement, and the use of those operations may provide significantly better performance. Also, there are other reasons why you might choose to use stored procedures beside performance. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286017 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
