Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: phranque
We have a php-mysql job site and as you know, it's very database-intensive. we're averaging close to 4000 uniques a day and growing.
Our paying customers are complaing of the slowness and mysql disconnects during peak hours.
4000 uniques a day
Please don't take this the wrong way, but I don't think this is something that would/should overload a (dual processor!) server...
If I were you, I'd start by taking a close look at the data model and the queries used, to see if they can be optimized. Perhaps you could add a few indices? (Improving the data model and adding indices can often give *huge* performance gains!)
As the poster above mentioned it maybe better to look at the coding structure to see why it is happening, also make sure all your sql queries are closed etc.