We have watched the web-server spike up to 100 percent utilization on
cumbersome queries before (afterward the page was modified to reduce the
number of results returned). Im not sure if this is supposed to happen but
it did.
Casey Cook
----------------------------------------------------------------------------------------
This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit
written agreement or government initiative expressly permitting the use of
e-mail for such purpose.
----------------------------------------------------------------------------------------
"Robert Shaw" <robertshawsjaws
@hotmail.com>
06/11/2003 04:39 PM
Please respond to cf-talk
To: CF-Talk <[EMAIL PROTECTED]>
cc:
Subject: query question
Hi All,
It appears a certain query of mine is causing our CPU to spike. We're
working on the query but what is strange is that it will hose CF. It was
my
uderstanding that CF passes the connection off so I would think it would
be
normal for the database server's CPU to spike but not for CF to cause the
webserver CPU to spike. If we kill the query it immediately goes back
down.
Does this sound right? I have not seen this happen before and am
questioning
if my logic is off.
TIA,
Rob
_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
