my apologies.... I did update my 'ignorance' on my SQL statements, but to
no avail... still hitting the 2000+ms mark...
-----Original Message-----
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 5:15 PM
To: [EMAIL PROTECTED]
Subject: Re: FW: LONG load times
Bad boy.. don't do select *. You know better than that. Name your columns
explicitly (don't know if that's the problem, but eliminate the obvious).
Additionally, try caching your queries.. either using CF's built in caching,
or
some sort of application variable scheme.
--
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]
David Sterling wrote:
> 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
-------------------------------------------------------------------------
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
