Refresh cached data in CRON job

Hi !



I think I understand that mautic have cached datas on database to speedup the load of some charts and tables.

We can setup the "Cached data timeout " in Mautic configuration.



My problem is, each time the cache need to be refreshed, Mautic is very slow to load.

It take more than 5 min to display the dashboard.





My question is simple : is it possible to refresh cached data in a CRON job ?



Otherwise, how to improve the cache refresh process ?

Hi !

I think I understand that mautic have cached datas on database to speedup the load of some charts and tables.
We can setup the "Cached data timeout " in Mautic configuration.

My problem is, each time the cache need to be refreshed, Mautic is very slow to load.
It take more than 5 min to display the dashboard.

My question is simple : is it possible to refresh cached data in a CRON job ?

Otherwise, how to improve the cache refresh process ?

I’ve also noticed that the dashboard is very slow. It renders the application unusable for every day use.

I tried to figure out the reason for the slowness. Queries that sum data from ma_page_hits are usually very slow. Dwell times chart is a good example.

I tried to tune mysql to better handle datetime range query, but with no luck. Thing is mysql refuses to use index on the date_hit field because the optimizer thinks table scan will bring better results than scanning the index.