Add unique index to msg_id and added column for improved query performance.

[ricardochaves]

Hello everyone,

I am submitting a pull request that addresses the issue of #24 slow query times and increased load on the database caused by the lack of an index on the msg_id column. My commit, titled "chore: add db_index for added and msg_id fields", adds a unique index to the msg_id column for improved query performance.

This change will significantly reduce the amount of time it takes to search for messages, as well as minimize the amount of resources needed by the database. By ensuring that the msg_id column is indexed, we can provide a more efficient database querys.

[github-advanced-security[bot]]

You have successfully added a new SonarCloud configuration ``. As part of the setup process, we have scanned this repository and found no existing alerts. In the future, you will see all code scanning alerts on the repository Security tab.

[sonarcloud[bot]]

SonarCloud Quality Gate failed.   

0 Bugs
0 Vulnerabilities
0 Security Hotspots
0 Code Smells

0.0% Coverage
0.0% Duplication