11.12.2018, 13:21
For example (My)SQL and clever data structuring can avoid most limits with these systems. This should rather be a question of good design than available memory.
There is no need for all clan info to be loaded at all times or even to be stored in the server's memory altogether.
Even without (My)SQL it is possible to do. For example have only the "main" data of a clan loaded when there is at least one player of that clan online. There might be 1500 clans (theoretically) but it's impossible for 1500 clans to be used at the same time. I'd even say it's highly unlikely for more than ~50 clans to be active at once even with 300 players. There are clan-less players (I assume) and having multiple people in one clan is why clans exist.
There is no need for all clan info to be loaded at all times or even to be stored in the server's memory altogether.
Even without (My)SQL it is possible to do. For example have only the "main" data of a clan loaded when there is at least one player of that clan online. There might be 1500 clans (theoretically) but it's impossible for 1500 clans to be used at the same time. I'd even say it's highly unlikely for more than ~50 clans to be active at once even with 300 players. There are clan-less players (I assume) and having multiple people in one clan is why clans exist.