I've a lot of long requests, but I never use select * FROM .. I'm using for example, SELECT cp.mycolumn, cv.lastname FROM c_particule cp, c_vector cv WHERE cp.id_c_table1 = cv.id_c_table2
Sometimes with a UNION command not more ... Do you think I need make something else ? I've read maybe jrunsvc donÂt like IIS 6.0 on windows server 2003 ?? -----Message d'origine----- De : Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] EnvoyÉ : mardi 21 juin 2005 15:04 : CF-Talk Objet : RE: Jrunsvc 100% cpu process Long running SQL is no doubt the cause which is backing up requests. Do you have any long running requests? Reports, select * from large tables... ? -----Original Message----- From: Jean-Michel DE FILIPPI [mailto:[EMAIL PROTECTED] Sent: 21 June 2005 13:36 To: CF-Talk Subject: Jrunsvc 100% cpu process Hello everybody, I've a real big problem on my server side. In fact I've Coldfusion 6.1 Mx installed on, and IIS 6.0 under Windows 2003 Server std Edition, width mysql 4.1. Every 60 minutes jrunsvc takes 100 % cpu time, I've already patch the connector to the last updates, I've try to use JRUN updater 5, and a lot of other things, but nothing work good. On my server side I've more than 10 web entries, for multiple clients. I can't find any explaination about this problem, someone have an idea please ? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210081 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
