Skip to content
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

Flattening Referrers.getWebsites is very slow and needs lot of memory #7120

Closed
tsteur opened this issue Feb 2, 2015 · 4 comments
Closed
Assignees
Labels
Bug For errors / faults / flaws / inconsistencies etc. c: Performance For when we could improve the performance / speed of Matomo.
Milestone

Comments

@tsteur
Copy link
Member

tsteur commented Feb 2, 2015

Maybe the same is valid for other reports. I haven't tried many. Referrers.getKeywords has the same problem.

Eg http://demo.piwik.org/index.php?date=2015-01-04,2015-02-02&module=Referrers&action=getWebsites&widget=1&idSite=1&period=range&flat=1

results in Allowed memory size exhausted

Opening http://demo.piwik.org/index.php?date=yesterday&module=Referrers&action=getWebsites&widget=1&idSite=1&period=day&flat=1 results sometimes in an "Internal server error" and sometimes in Allowed memory size exhausted

Maybe there are already similar issues in this case simply close it!

@tsteur tsteur added Bug For errors / faults / flaws / inconsistencies etc. c: Performance For when we could improve the performance / speed of Matomo. labels Feb 2, 2015
@tsteur tsteur changed the title Flattening Referrers.getWebsites is very slow Flattening Referrers.getWebsites is very slow and takes lot of memory Feb 2, 2015
@tsteur tsteur changed the title Flattening Referrers.getWebsites is very slow and takes lot of memory Flattening Referrers.getWebsites is very slow and needs lot of memory Feb 2, 2015
@mattab mattab added this to the Short term milestone Feb 10, 2015
@mattab
Copy link
Member

mattab commented Feb 10, 2015

There are no similar issue, besides the related memory usage of yearly archives #6846

@tsteur
Copy link
Member Author

tsteur commented Mar 8, 2015

Might be fixed by #7336

@mattab mattab modified the milestones: Piwik 2.12.0, Short term Mar 9, 2015
@mattab
Copy link
Member

mattab commented Mar 9, 2015

Very likely yes. I'll push a beta to demo now so we can confirm it is!

@mattab
Copy link
Member

mattab commented Mar 9, 2015

Wow, those reports now load in a few milliseconds... that's impressive, and fixed 👍

@tsteur tsteur self-assigned this Mar 9, 2015
@tsteur tsteur closed this as completed Mar 9, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug For errors / faults / flaws / inconsistencies etc. c: Performance For when we could improve the performance / speed of Matomo.
Projects
None yet
Development

No branches or pull requests

2 participants