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]
