Help merchants to deal with over-populated SQL tables

[matks]

Is your feature request related to a problem?

A shop that has been running for years might accumulate a huge quantity of outdated datas: logs in ps_log table, emails of users who have not shopped for a long time, abandoned carts, cart rules with single usage that have been used a long time ago ...

All of these SQL rows will stay there and make SQL queries being run against the database slower.

Describe the solution you'd like

Ideally ? PrestaShop would be able to identify "useless data" and suppress them. For example "logs that are X months old" (and merchant/webmaster can configure X).

Alternatives you've considered

• a tutorial for merchants about how to identify and clean their old data
• a tutorial for developers about how to identify and clean their old data
• a warning system, able to monitor SQL tables size and properly warn developer/merchant about possible entanglement

Idea coming from @olecorre feedback

[prestashop-issue-bot]

Thanks for opening this issue! We will help you to keep its state consistent

[PierreRambaud]

Could be a pscleaner option. But i'm not sure about your last sentence, the size can depend on the server configuration, it's up to the user to settle it.