Thanks for the responses. I know which query it is so fixing it is in the works, one of my colleagues is also looking into it. I still don't think it makes sense that the query going to a database on a different server woud cause CF to spike, I'd think it would cause the database server's cpu to spike. But if anyone has any other feedback as to why this would hapen and if it is expected behavior we'd appreciate the input.
TIA, Rob 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. ---------------------------------------------------------------------------------------- _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
