Yes of course a query will be slightly slower than running direct in QA but
not by a huge amount - certainly nothing to worry about.
Also, are you saying that the execution of the SP is taking 0ms in QA or
just its component parts? If you have named your SP with a prefix of sp_
then this will also have a detrimental effect on performance.
_____
From: Micha Schopman [mailto:[EMAIL PROTECTED]
Sent: 14 July 2004 12:34
To: CF-Talk
Subject: RE: Tuning DB connections?
The queries are optimized icw execution plans, etc. Every requests also
turns out to take 0ms in Query Analyzer. The only slow part is after
that, .. when the package is send to ColdFusion Server as the return
value for the cfquery :-)
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]
