I had a similar problem too - we restructured the queries to use INNER JOINS and it solved it. It went from CPU flat out to barely a blip on the radar screen
********** Kevin Parker Web Services Manager WorkCover Corporation e: [EMAIL PROTECTED] w: www.workcover.com p:+ 61 8 8233 2548 f: +61 8 8233 2282 m: 0418 806 166 ********** -----Original Message----- From: Robert Shaw [mailto:[EMAIL PROTECTED] Sent: Thursday, 12 June 2003 9:09 AM To: CF-Talk 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