Request: MySQL Database optimization

[39ma]

I am reaching out to suggest potential optimizations for the database. While the current configuration is functioning adequately, I believe implementing indexing in tables could enhance performance.

Additionally, regarding the management of weapon_id rows, a more efficient approach might be to utilize a single row for steamid with additional columns for each weapon_id. This could streamline the data structure and potentially improve database efficiency.

Another aspect worth considering is the implementation of an automated cleanup system within the database. This system would remove entries of players inactive beyond a specified duration, as determined by a cvar in the plugin configuration. An example of this functionality is illustrated in the existing script at this link.

I appreciate all the efforts put into the project. I am hopeful that these suggestions will be considered and look forward to potentially seeing them integrated soon.

Thank you for your continued hard work and commitment.

[rabi07]

+1

[enzo405]

+1