Hi all !
I’ve a Mautic 1.2 instance that is registering a lot of traffic, most of them Anonymous Leads.
The table “page_hits” have more than 2 million of records and the problem comes when I try to open in Mautic the statistics page of a Landing Page, the application gets locked during several minutes and it blocks the application.
Monitoring database activity I’ve seen that when I try to open the info page of a Landing Page (not when I try to edit it) there is a query that takes these several minutes to finish because is querying that table:
I guess that this query is doing a heavy work looking through that 2 millions of rows.
Do you think that is there any way to optimize that query?
Or perhaps, am I suffering any data inconsistency problem?
Thanks a lot!