Skip to content

Limit the growth of the database #1003

Open
@damianperez

Description

@damianperez

🎉 Feature Request

Limit the growth of the database

Summary

Setting the days to save in logs of the tables in webhook

If the bot exceeds a number of users that any server service can handle, the tables begin to grow exponentially. It would be good if (for example, the request_limiter table) does not store more than what is previously configured in the bot initialization. With thousands of records in the db, cleanup is almost impossible.
A possible solution would be to find an appropriate key in the tables so that you can do:
insert ignore into .... on duplicate key update ...
If not, compare the preset number of records in initialization with the amount in the table and clean them automatically.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions