I would suggest that you try to eliminate a few more culprits and
possibilities first (code, connections, SQL syntax, etc..).
You could do this by turning on the SQL server debugging feature in CF
Server Admin. Use it to generate the actual SQL statement that is getting
created thru your code and sent to the DB.
Copy this statement and paste it into the SQL Admin Query tool and execute
it directly against the DB (without passing thru any ODBC connection, code,
etc..). Does it run any faster? If no, then you can probably pinpoint the
issue in either your SQL statement or the DB itself.
If it does run faster executing directly against the DB, check your code or
ODBC connection or any elements that the SQL passes thru on it's way to the
database. I know this approach sounds simplistic, but a lot of times with
troubleshooting, it's tough to see the forest thru the trees.., if you know
what I mean.
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of David Sterling
> Sent: Friday, March 16, 2001 4:54 PM
> To: '[EMAIL PROTECTED]'
> Subject: FW: LONG load times
>
>
>
> 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
