search

muukis / l4dstats

SourceMod plugin (Custom Player Stats) for collecting statistics and creating player ranking in Left 4 Dead and Left 4 Dead 2 games
https://forums.alliedmods.net/showthread.php?t=115965
17 stars 9 forks source link

DB optimization for webstats #18

Open HairyMilkshakes opened 6 years ago

HairyMilkshakes commented 6 years ago

Not sure what other solutions come to mind, but the problem I'm having with larger DBs is just a huge slowdown in trying to load the main webstats page.

Apart from pruning old/inactive users, what other options are there?

muukis commented 6 years ago

Indexes could optimize query execution times. I don't think remember if there are any indexes at the tables currently? Also, don't know if MySQL actually supports indexes?

muukis commented 6 years ago

https://dev.mysql.com/doc/refman/8.0/en/mysql-indexes.html

HairyMilkshakes commented 6 years ago

I saw that while searching earlier this week - not sure how it would be implemented into this plugin to be exact.