search

kangarko / ChatControl-Red

Issue tracker and documentation for the next generation ChatControl Red, the most advanced chat management plugin.
49 stars 23 forks source link

Suggestion: H2 or SQLite database support #2550

Closed Pantera07 closed 8 months ago

Pantera07 commented 8 months ago

Summary

Currently ChatControl Red has significant performance degradation when MySQL is not enabled. For servers where MySQL is not available, changing YamlConfig to H2 or SQLite instead can significantly improve performance. https://github.com/kangarko/ChatControl-Red/wiki/Performance#non-mysql-users-high-cpu-drain-when-on-player-quit

What would happen if we didn't implement this feature? Why not having this feature is a problem?

Servers without MySQL enabled will experience significant performance degradation when players leave or log in.

kangarko commented 8 months ago

I had an user configure his mysql.yml > "Line" key for flatfile/H2 storage, I unfortunately don't remember the structure but it should be doable. I strongly recommend MySQL/MariaDB when having higher workloads.

Pantera07 commented 8 months ago

I had an user configure his mysql.yml > "Line" key for flatfile/H2 storage, I unfortunately don't remember the structure but it should be doable. I strongly recommend MySQL/MariaDB when having higher workloads.

How can I set it up? Will this be added in the next update?

kangarko commented 8 months ago

Try asking in our Discord community. I don't remember what he put into the Line key, but it should be possible even now. No sorry I don't plan on adding h2 or litestorage specifically.