What I have found that if you do a stored procedure in a loop it defeats the
whole purpose of a stored procedure becuase you are doing the query over and
over again. Though just in theory it would work faster because instead of
cfquery building your query it would already be built for you. I figure it
would work better with inner and outer joins, the more complicated the query
the better the performance difference. I have never heard anyone say that
stored procedures give CF worse performance. Do some testing yourself. Take
some queries that take a long time and convert them over to stored
procedures and see what happens, can't hurt.
Robert Everland III
Web Developer
Dixon Ticonderoga
-----Original Message-----
From: Mike Amburn [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 27, 2000 10:20 AM
To: Cf-Talk
Subject: do stored procedures REALLY help performance?
one of our senior developers is vehemently arguing against stored
procedures, saying that in his testing he has found that stored procedures
either perform equal or worse than CFQUERYs.
can anyone provide actual data to support stored procedures over CFQUERYs?
-mike
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
