That is connection time, friend. Play with your 'maintain connections' with
a simple query in your application.cfm and I bet you'll be good.
(Also consider query caching - you'll open some doors to new possibilities..
he he)
Nate Nielsen
[EMAIL PROTECTED]
(817) 726-8644
----- Original Message -----
From: "David Sterling" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 16, 2001 4:38 PM
Subject: LONG load times
> 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
>
-------------------------------------------------------------------------
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
