How to implement a minimum load on mysql, with a strong visit to the app?
Good time of day!
Comrades, interested in the question: which is better to use, or how best to organize multiplayer action on a single application.
Describe the situation: there is a module that contains the entrance to several locations. When you log on, the user identificireba in the database, at the moment he is in one of several locations. When you click on locations respectively a record changes. In each location, you can attack those who at the moment is in the same place. Our database is the table, duplicating the user's settings, specially for the module, if in a given cell will be 0 after the attack, the entry is removed and the user respectively moves to the beginning location.
Question: with this approach, it is clear that if a user in a module of 50-100 base will tolerate, but if they are 1000+, respectively, then there is a lot of burden on mysql with a large number of queries. Are there any ideas to overcome? Not cost-effective to use sqllite? Or better?