If you're trying to produce a results page by crunching thru a million records, then I expect that's the problem.
I have a CF/mysql stats system on several sites - all on the same win2k server - and they run fine. The key for me was to archive old results for Week 1, 2, 3 etc. so the routine doesn't have to parse thru old data. Just pulls result totals out of a separate db and displays them. Mysql max allows you to use innodb and bdb-type tables, which give row locking and transaction support. V4.01 is fully acid-compliant, I believe. Slower and not something I'd play with if I didn't specifically need it. mysql max eats about 4 times the memory as plain old mysqld-nt.exe. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -----Original Message----- From: CFTalk [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 9:57 AM To: CF-Talk Subject: Problems with MySql Hello All, I have a question that I hope someone here can help me out with. The problem is that I have a stats program running in the background of every page. So when someone hits my website it insert a record in the mysql database. The problem start when the database is bigger then 1 million records. When I try to run the stats program the cpu on ther server stays the same and after about an hour the page timesout without any errors. This used to work very well...Is it because of the amount of records??? I have tables for every month... I am using a windows 2000 sp2, mysql 3.23.47-nt with 1gig of ram running coldfusion 5.0 prof. This was working very well last week. Does anyone have any idea why this is happeneing... Also...There is something call mysql max..Does anyone know if I should be using this or not??? We don't really have th emoney for oracle or mssql...So I would like to make it work with mysql... Thanks for all the help. Joel ______________________________________________________________________ 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
