[daffyy]

For a long time I have been struggling with the problem of long loading of plugins (most often based on mysql), after changing the map plugins such as:

weapons.smx (https://github.com/kgns/weapons)
kento_rankme.smx (https://github.com/rogeraabbccdd/Kento-Rankme)
shop.smx (https://hlmod.ru/threads/shop-core-fork.38351/)

take even a few minutes to load.

What is strange, e.g. gloves work right away and the problem only occurs with those above, changing the database to another hosting and to different vps does not help - it is always the same and no matter where the database is located.

Anyone have had such a problem or have any suspicions as to what might be causing it?

[pedrotski]

Few things I learned going above 30+ players. The first 2 are the most important things on this list.

1. Make sure hibernation is off.
2. Make sure your mysql database server is in the same datacenter as your actual game server if possible. (lower latency is better in this case)
3. Make sure you're not loading or unloading plugins on map changes (this causes everything to reconnect)
4. Keep your database clean by purging inactive players.
5. Set a timeout for less critical stuff. Not sure how effective this is for anyone else but I staggered plugins that were less important with a longer time out. That way the more notable stuff is loaded first.

Just a tip, on our bigger servers we actually set weapons.smx to load up locally using sqlite instead of mysql as it would take forever.