Sorry we are using SQL Server completely. Neil
----- Original Message ----- From: "Bryan Stevenson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 21, 2002 6:44 PM Subject: Re: Heavy CF Load > If you are using Access that is ;-) > > 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: "Bryan Stevenson" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, June 21, 2002 3:39 PM > Subject: Re: Heavy CF Load > > > > 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] > > > > > > > > > > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
