Could it be that the first query takes so long because it's having to
initiate the connection to the database? Check your ODBC Data Source
settings.
At 04:38 PM 3/16/01 , you wrote:
>List,
>
> I have an application that is running SQLServer 7.0, on an Windows
>2000 Server, and CF Server 4.5.... For the last few months during
>development, my pages have been loading really fast, load times have been
>around 200-500ms, and these are the most extreme <CFQUERY> intensive
>pages... But the other day I was going through, some of the pages and load
>times are hitting 2000+!!!!!! ouch!!!! we have rebooted the Server, and
>the SQLServer...
>
>What is weird is that if a page has lets say 4 queries, its always the first
>query that has the extreme processing time.... If you remove that query
>that looks like the problem, the next query in line picks up the extreme
>time...... what could cause this.... any ideas?????????
>
>David Sterling
>Square One Inc.
>Cold Fusion Developer
>
>
>-------------------------------------------------------------------------
>This email server is running an evaluation copy of the MailShield anti-
>spam software. Please contact your email administrator if you have any
>questions about this message. MailShield product info: www.mailshield.com
>
>-----------------------------------------------
>To post, send email to [EMAIL PROTECTED]
>To subscribe / unsubscribe: http://www.dfwcfug.org
>
Jeff Mayfield
Wirehead Technologies
1515 N. Town East Blvd.
Suite 138-442
Mesquite Tx. 75150
v 972-698-8550
f 972-698-8551
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
