Skip to content

Improvement of statistics for highly accessed layers #993

Closed
@thomaspiller

Description

@thomaspiller

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

No one assigned

    Type

    No type

    Projects

    Status

    In prod 🚀

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions