For example, I have a SP that uses about 10 select statements to retrieve data from 4 different databases and about 15 different tables. The 1st time it is run it takes about 10-15 seconds to return 2,100 rows. If I wait a few seconds and run it again it takes about 3 seconds to return the same rows. That is where the benefit of SP's are, that once run all future runs are significantly faster.
______________________________________________________
<file:///E:/EUColor.gif>
Bill Grover
Manager, Information Systems Phone: 301.424.3300 x3324
EU Services, Inc. FAX: 301.424.3696
649 North Horners Lane E-Mail: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
Rockville, MD 20850-1299 WWW: <http://www.euservices.com/> http://www.euservices.com
______________________________________________________
-----Original Message-----
From: Micha Schopman [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 26, 2004 6:53 AM
To: CF-Talk
Subject: RE: stored procedures
Stored procedures are NOT pre-compiled. This is a common made mistake.
Only the execution plan gets cached, but the stored procedure is
compiled upon execution.
Micha Schopman
Software Engineer
Modern Media, Databankweg 12 M, 3821 AL Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
