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.