See report in : http://forum.piwik.org/read.php?2,70690
The query should have AND visit_last_action_time > ?
clause to make it use the INDEX and perform better.
I have this problem too. piwik has become unusable since the critical update from 1.0.
(In ) Refs #1966 Spy should not keep doing requests when the screen is not showing the widget anymore
Piwik was very slow for me and unusable; disabling "Live!" made it usable again.
we must take a decision: either we disable Live! by default for all new installs, or we fix these performance issues
I fixed this issue, just and introduced a new bug tracked in: #2076
this obviously wasn't fixed properly
(In ) Fixes #2145 as far as I can see, it should be fixed, but I've been wrong all previous times so testing is very much welcome! thx
Refs #1966 Improving visitor log performance by rewriting the query
(In ) Fixes #2259 Kuddos SteveG for spotting this issue!
Refs #1966 cancel the other ajax request as well, when something wrong happened in the previous request + fixing the missing order by
wow that looks fast now!! Will keep an eye on it