Hello,
I’m wondering does anyone have any ideas on how to optimise the database to improve performance for mautic. I’m running an instance with 2 million+ leads. The cleanup cron runs once a week, but the email stats table is massive, and any campaigns / segments that query this often take a while or don’t finish before the cron tries to start again.
Is there anything that can be done to ‘archive’ old data or make it easier to run queries on segments / campaigns?
I’ve development experience and I’m happy to contribute to the project on github if there are any ideas, suggestions or open issues already for this?
Thanks