DB optimization for webstats

[HairyMilkshakes]

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]

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]

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

[HairyMilkshakes]

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