[bee]

Maybe you should change the db structure, to optimize sql queries, use a caching system to delivery static content, or you can ask a more experienced developer to look over db structure and give you ideas. 9000 users don't seem that many to make the server run slow...

[aonic]

Also agree with this. I'd be happy to help you by taking a look and sharing my thoughts on where improvements can be made in the DB structure, configuration, scalability, as well as places where caching will give good results vs implementation costs and effort.

Feel free to email me, address in profile.

[sagacity]

> 9000 users don't seem that many to make the server run slow...

I second that, especially when you have moved mysql on a separate server. I'm sure you're missing something basic here (as happens to many from time to time :-)).

[digamber_kamat]

Our server is not slow at the moment. It is pretty responsive. But as 9000 reaches closer to 100000 I am sure existing safe-gaurds will not be enough, so I am asking what else can be done.