Welcome to WebmasterWorld Guest from 18.104.22.168
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!)