Run a SQL profiler and see what happens in the SQL server regarding
processing/execution time with the two methods.





   _____  

From: Micha Schopman [mailto:[EMAIL PROTECTED]
Sent: 14 July 2004 13:22
To: CF-Talk
Subject: RE: Tuning DB connections?

No change when using the cfstoredproc method. Still the same odd latency
changes. With both the cfquery and the cfstoredproc method I saw a 15ms
requesttime passing by. This would mean there is no 16ms hartbeat
signal. Interesting.
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]

Reply via email to