Closed
Description
The display of statistics for layers that have been activated thousands of times takes a long time in the MapX interface. There is a bottleneck at the database level where the creation of statistics involves a time-consuming join to obtain the country related to the IP addresses. By including the country code directly in the mx_logs
table, it would no longer be necessary to perform this join and the query should then be almost instantaneous. An update to the mx_logs
table is therefore required, and the query generating the statistics will need to be updated to avoid this costly join.
Metadata
Metadata
Assignees
Type
Projects
Status
In prod 🚀