Hi
I run www.bettingadvice.com, and due to some inproper programming from those who designed the site, I'm in some trouble now.
THe site runs on a 1,7 Ghz with 1 gig Ram.Red Hat 7.0 with Ensim 3.0 on top.Mysql 3.23.49 a, Php 4.06 with Php Accelerator 1.3.2 installed (and working, I believe).
The site get's around 100000 unique per moth, and 6-700000 pageviews.
Load on an average day is around 1.5 (15 min average) on peak times, but often hit loads of 20 in spikes in the weekends.
THis is ofcourse worrying.
I run a script on the site, called "Latest Picks" which is poorly written, and causes heavy load on the server. This php-script basically brings up data from the database, and displays it. The problem is that there is no caching on it, so for every pageview, the same quieries are performed.
Now I'm thinking of a possibility to cache this output, perhaps by dumping the mysql result into another table in the database, and then bring the date up from that table instead, perhaps every 5th minute or so.
Does anyone know how to do this, and have you got any example code?
I'd be very happy for some help, and would also be willing to pay for programmers which can help me get the site more "streamlined".
Regards
Terje Grefstad
