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
Real time map and Visitor Log may be slow on a very large traffic site #12722
Comments
Can anybody explain this?
My understanding is, that the query will first check for every visit that happened after time 0 and than afterwards for everything from current time. So it will check every row 2 times, but only rows with second check true will be included. |
Yeah the time range is huge! |
The reason for that is imho located in https://github.com/matomo-org/matomo/blob/3.x-dev/plugins/UserCountryMap/javascripts/realtime-map.js#L151 |
Good find 👍 |
I've created a PR for that. But I'm not sure if it will improve the performance of the real time map much... |
Will mark as closed for now as we have at least fixed the obvious issue. I would re-open another issue then in case the performance problems persist |
I'll reopen it right now as it is not properly fixed. I could create a new issue instead but there is no point in it. |
…"" (#12761) * Revert "Fix syntax vor 'SHOW COLUMNS FROM' (#12759)" This reverts commit f69c1f6. * Revert "fix #12722 (#12756)" This reverts commit 6c3ed18. * Revert "When setting or resetting User ID, do not update the Visitor ID in the first party cookie (#12742)" This reverts commit fdb161b. * Revert "Show information in visitor profile if dataset was "truncated" (#12376)" This reverts commit 14ba6a4.
@Findus23 you re-opened the issue, did you experience it again or have some more info maybe? |
@mattab Thanks for the info. |
Only look at last 3 days for real time map. In theory even only the last 1-2 days is enough since it is called real time so for sure we wouldn't need to include anything older than 24 hours.
…"" (matomo-org#12761) * Revert "Fix syntax vor 'SHOW COLUMNS FROM' (matomo-org#12759)" This reverts commit f69c1f6. * Revert "fix matomo-org#12722 (matomo-org#12756)" This reverts commit 6c3ed18. * Revert "When setting or resetting User ID, do not update the Visitor ID in the first party cookie (matomo-org#12742)" This reverts commit fdb161b. * Revert "Show information in visitor profile if dataset was "truncated" (matomo-org#12376)" This reverts commit 14ba6a4.
On a site with 100,000 pageviews and 1M events per day, the Real time map is very slow to load. The slow SQL query is:
It would be great if we could find a way to make the Real time map load faster.
The exact same query is triggered from the Visitor Log for the same day/website.
The text was updated successfully, but these errors were encountered: