5 ms·
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
by bee 16y ago
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...
- sagacity 16y ago> 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 16y agoOur 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.
- aonic 16y agoAlso 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.