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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
