I can help you with ideas of refactoring.
Murat BIYIKLI wrote:
I use a Linux web server with PHP-MySQL. The hardware is good enough with 2GHz CPU and 1 GB RAM. and 7200 Cycle/min Serial ATA IDE HDD. Only one web site is running on it and on every page of that site, it searchs for a value in Users table including 78000 records and updates that value. The MySQL crashes on everyweek and needs to be killed and restarted, sometimes the server becomes unreachable and needs to be restarted. Do you think MySQL is not stable or bad configured? How to optimize that and monitor what goes wrong, or is it time for Oracle?
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php