Hello, i have big problem with this plugin, it is not optimized for higher traffic websites!
When it gets over 100k messages and there are 500+ users online the site gets REALLY slow, it takes 10 seconds just to open 1 page.
The server is an overkill for a site like this and still it collapses (AMD EPYC 7281 16-Core Processor, 15 cores  100gb ram and nvmE disk). We did add any possible indexes and still it totally destroys the website.
The second i disable this plugin the site opens like localhost
Can you please give any help or suggestions about this problem?

@oscman
Well there is premise if you have site with 100k messages as well as 500+ users online, you have own developer that is optimizing queries to get best performance.
There are few solutions:
- run messages maintenance more often, like keeping messages for one month
- archive messages
- create several supporting standard table and fill this table with most extensive queries, then update model to use content from these tables instead of using queries
- reduce operations against plugin tables (like messages count in header etc)