Does it return a huge amount of data? That could tie up the odbc driver. Is
your CF server's CPU peaked at 100% for some reason? If you're running on
two servers, the DB server could be fine, but the CF server could be
overloaded. Does it do it every time or just the first time?

Steve Nelson

  _____  

From: Frank Mamone [mailto:[EMAIL PROTECTED]
Sent: Monday, March 29, 2004 12:36 PM
To: CF-Talk
Subject: Slow query on CF5 why?

WHat are the possible reasons for a query taking 2.3 seconds thru CF(CF5)
but a few milliseconds in Query Analyzer?

Same DB server.

Thanks,

Frank

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

Reply via email to