Performance of PageStatistics::getTotalPageViewsForOthers
Permalink
Has anyone ever had a problem with the method mentioned in the subject?
It fetches the data by executing such a query:
The "not in" operator is rather ugly and slows down the system a lot. Negative logics in SQL databases are never nice.. In my case it took more than 30 seconds to render the dashboard - dedicated server with quite a lot of performance.
I had to rewrite some stuff which depended on PageStatistics but ended up removing all the stuff related to it. I just checked the lastest version on github, same issue..
Any comments on this?
Thanks,
Remo
It fetches the data by executing such a query:
select count(pstID) from PageStatistics where uID <> ?
The "not in" operator is rather ugly and slows down the system a lot. Negative logics in SQL databases are never nice.. In my case it took more than 30 seconds to render the dashboard - dedicated server with quite a lot of performance.
I had to rewrite some stuff which depended on PageStatistics but ended up removing all the stuff related to it. I just checked the lastest version on github, same issue..
Any comments on this?
Thanks,
Remo
