here is a sample Query that is taking an obsurred amount of time to
process...
>>get_news (Records=2, Time=2109ms)
>>SQL =
>>SELECT *
>>FROM Elk_News
There are only THREE fields in this table, and as you can see it only found
two records... how could it take 2100ms to do this process????
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 4:53 PM
To: [EMAIL PROTECTED]
Subject: Re: LONG load times
Last time that happened to me we had added a field to a table and did not
re-index the table to include that field. Before I re-added the index my
queries were timing out, afterwards it ran literally in seconds.
CC
David Sterling <[EMAIL PROTECTED]>@dfwcfug.org on
03/16/2001 04:38:56 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
cc:
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
