> 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.
What you have to remember is that even though CF "passes" the query to the database server, it still has to sit and wait for the result, now, during this time, if the data coming back is complex or too big (say several hundred, thousand records), then it'll spike as it's trying to get the information from ODBC/JDBC/OLEDB... How many records are being returned, and how complex is the SQL? If the SQL is horribly structured, or there aren't any indexes, then the query may take ages to execute... HTH (in some way or another) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
