Make Visitor Log load very fast even with hundreds of thousands of visitors, or if a visitor views thousands of pages #3097
Labels
Bug
For errors / faults / flaws / inconsistencies etc.
c: Performance
For when we could improve the performance / speed of Matomo.
Critical
Indicates the severity of an issue is very critical and the issue has a very high priority.
Milestone
On a test Piwik, select year period, then visitor log, loading the page is really slow and I suppose could even crash Mysql in some cases.
When looking at year or month or day it should be as fast in all cases, since we select the last N visitors for the last day of the period.
I thought this was fixed already, but it isn't, we should run a clever SQL that is fast just like when looking at one day data.
The text was updated successfully, but these errors were encountered: