Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Improvement of statistics for highly accessed layers #993

Open
thomaspiller opened this issue May 21, 2024 · 0 comments
Open

Improvement of statistics for highly accessed layers #993

thomaspiller opened this issue May 21, 2024 · 0 comments
Labels
db improvement priority 2 UX-UI Issue related to user experience

Comments

@thomaspiller
Copy link
Collaborator

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.

@thomaspiller thomaspiller added improvement UX-UI Issue related to user experience db labels May 21, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
db improvement priority 2 UX-UI Issue related to user experience
Projects
None yet
Development

No branches or pull requests

2 participants