Well...first culprit to check is the version of MDAC (Microsoft Data Access Components) on the server. There ahve been so many released, I don't know which you should have, but make sure it's the latest (check M$). This CPU spiking was a reulst of a MDAC bug in a version back around CF4 I think and was temporarily re-introduced around version CF 4.5. What would happen is some queries (even simple SELECTS on a little data) would spike the CPU and a restart would be needed to recover.
HTH Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "Neil H." <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 21, 2002 3:00 PM Subject: Heavy CF Load > I have a customer who is running a site. It is getting a ton of traffic and > CF is constantly pegged at or about 99%. I am looking for some ideas to > suggest to the customer and his developer to improve speeds on the site. > His database is just one table with a lot of information about the people > who signed up First Name, Last Name, State and one more flag in addition to > an identity. > > The site is www.PatriotDrive.com > > Please let me know what you think. > > Thanks, > > Neil Heuer > [EMAIL PROTECTED] > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
