I don't have any metrics on this, but I will tell that I've absolutely seen
HUGE increases in speed when going to a stored procedure versus using a
standard query.  Of course, my large increases were due to the fact that I
was no longer using nested queries to perform a task that I am now using
cursors (T-SQL) for.

It takes a little longer to set up, but if you have an intensive query or
set of nested queries, do yourself a favor and go with the stored proc.  The
processing gain will blow your mind.  My query dropped from 1,2,3 minutes to
process to 8-12 seconds.

- Matt Small

  _____  

From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent: Friday, September 17, 2004 10:18 AM
To: CF-Community
Subject: Metrics?

Does anyone have any metrics outlining the differences between the
following:

Using CFSWITCH  vs. CFIF statements (looking for performance numbers)

Using CFStoredprocs vs. standard CFQUERY

  _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to