Hi Tim. Good to know. About the mysql: I am caching the queries now. In queries I was getting more than 10000 msecs, now I get 2/3msecs. It's solving very well the problem here.
When you say "returning what is absolutely necessary" you mean LIMIT x,y or SELECT IwantThis, IwantWhatever from Table? Or both? Daniel At 02:59 PM 12/14/2001 -0600, you wrote: >I've got CF5 on a dual 1ghz P3 box, and MySQL on a dual 1Ghz P3 scsi raid >box (both have 1GB Ram) - purchased from pogolinux.com fwiw. > >it probably goes without saying, but make sure your queries are only >returning what is absolutely necessary... we were sloppy early on and didn't >limit the queries to just the number of records we needed.... later on when >we fixed it we were able to cut our total page loads by a factor of 10. > >Tim Storm >FatWallet.Com > >----- Original Message ----- >From: "Daniel Chicayban" <[EMAIL PROTECTED]> >To: "CF-Linux" <[EMAIL PROTECTED]> >Sent: Friday, December 14, 2001 2:52 PM >Subject: mysql/coldfusion/linux/dual processor > > > > Does anyone has unsuccessful or successful cases running cf with mysql, cf > > 5 and dual processor box? > > > > I have an app that is demanding too much from the mysql server. I wonder >if > > I change a pIII 500Mhz (512mb RAM) to a powerful one or maybe two > > processors, I would have more performance in my queries. > > > > Any article, faq etc would be great too. > > Thanks in advance. > > > > Daniel > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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 ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
