One of our programmers got good at, and we are now using, Transact/SQL
(T-SQL) to great advantage. Stored procedures probably do speed things up,
make it easier to correct or extend a commonly called procedure, etc. He
found, for us anyhow, that it is easier to pass variables and such around
using CF vs. passing them into the SQL server. It just saves development
time. We often store queries in includes and call them as needed, so changes
are not a big problem.
-Gary
> -----Original Message-----
> From: Robert Everland [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 27, 2000 9:39 AM
> To: '[EMAIL PROTECTED]'
> Subject: RE: do stored procedures REALLY help performance?
>
>
> 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.
------------------------------------------------------------------------------
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.
