before reloading CF.. try to reapply the latest MDAC. sounds like some of
your db drivers may be the root cause.
-----Original Message-----
From: Bruce, Rodney [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 2:01 PM
To: CF-Talk
Subject: RE: OT: Way Slow web pages
We upgraded to CF5 in June and this is the first time this slow down has
happened.
I have stopped and restarted all the services, but for us this has not seem
to help.
Looking at the Debug info, the queries are running slow. taking up to 10X as
long.
a simple bd hit to get a page count is taking ~900ms. the few pages without
any queries seem to ok.
This is happening in both ACCESS and SQL 7, We are testing the same pages
with both and both are taking this performance hit, so its not just Access
being slow or SQL having a problem.
Next option I can think of which I DON'T want to do would be to reload CF.
just reloaded SQL and ACCESS.
Thanks for the info
-----Original Message-----
From: Mueller, Ben [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 12:33 PM
To: CF-Talk
Subject: RE: OT: Way Slow web pages
Did you have this problem under an earlier version of CF?
Ever since we upgraded our development server to CF 5, we've been getting
these periodic slow-downs that we haven't been able to track down yet.
We've only noticed it on a page which normally takes about a minute or two
to complete. The page reads over a file directory, parses out some data
from those files (some XML, some CF) and inserts information into our
database (SQL 7). I've stripped the code down in an attempt to isolate bad
code, but so far I haven't found an obvious culprit. Also, we've checked
all the standard things: hanging threads, memory leaks, etc, and so far all
of that stuff looks normal.
We set up a test page which sets a variable something like a million times
(in a loop), and then prints the total elapsed time the page took to
execute, using the getTickCount() feature. The strange part is that the
execution time on the test page doesn't change, regardless of whether the
slow-down is happening or not.
We never saw this problem under 4.5, and cycling the service fixes the
problem.
Granted, we haven't had as much time as we'd like to isolate the problem, so
it could be a configuration problem on our server, or bad code, but the
problem cropped up just after we upgraded to CF 5.
-----Original Message-----
From: Bruce, Rodney [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 2:21 PM
To: CF-Talk
Subject: RE: OT: Way Slow web pages
1. yes, and has been, this speed problem is new
2. task manger shows RAM almost totally free
3. have over 60GBs free
4. will look into this, can you suggest some programs that can do this?
5. using a monitor on the server, no connection
6. Have updated dat file from Norton. Are there virus it will not catch.
7. Coding/scripting is the same when the pages were running fine. same
page/code was running ~200, is not at ~2,000.
-----Original Message-----
From: Fuon See Tu [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 12:11 PM
To: CF-Talk
Subject: Re: OT: Way Slow web pages
here are some things....
1. Virus Scanner running on server
2. Low memory
3. Low HD space
4. Bad memory
5. Bad Connection
6. Virus
7. bad coding/scripting
>From: "Bruce, Rodney" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: OT: Way Slow web pages
>Date: Thu, 23 Aug 2001 12:04:37 -0700
>
>sorry about the very broad question.
>
>but what are some things that could cause a web server to almost be 10times
>slower.
>web pages that were taking ~3,000ms are up to ~30,000. same with others
>that
>were at ~200ms are at ~2,000.
>
>is seems to be the query/db access time. it's affecting both Access and
>SQL backed web pages.
>
>Access itself seems to be running fine. but SQL Manager seems to be
>running
>real slow. takes over 2 mins to just display a list of the tables when a
>db
>is chosen. and then almost 4 mins to display the design table.
>
>I have reviewed the logs, the only listing, but is not consistent is that
>the administrator account fails on accessing \winlogon Object type:
>desktop. EventID: 560 looks to be trying the access \winlogon once a sec.
>but this is not going on all the time. This will happen for about 3 mins
>then stop.
>
>the changes to the server I can think of, MS office and SQL 7 have both
>been
>reloaded. This is not an active server, once this problem gets fixed, it
>will be, so work load is not a factor. It is a WINNT 4.0, 1 GB RAM, dual
>800mhz CPUs. using CF 5.
>I have tried to turn the different services off,(CF, WEB, SQL), but this
>does not affect the problem.
>I am at a loss. any suggestions will be appreciated.
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
