Some SQL queries generated by Live plugin API are heavy SQL queries #9499
Labels
c: Performance
For when we could improve the performance / speed of Matomo.
Milestone
We have experienced a case where Live SQL queries can be slow. For example the queries run for two hours or more. Here is an example of such query running slow, and the explain extended:
This occurs especially when date ranges include many days such as:
For now we cannot easily improve this so we simply document, via this issue, that there may be performance issues when Live plugin (eg. Visitor log) is used with very wide date ranges.
The text was updated successfully, but these errors were encountered: