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

Loading Flattened Page Urls report for 5 years long date range takes 45 seconds to load #7809

Closed
mattab opened this issue May 1, 2015 · 4 comments
Labels
c: Performance For when we could improve the performance / speed of Matomo. Task Indicates an issue is neither a feature nor a bug and it's purely a "technical" change.

Comments

@mattab
Copy link
Member

mattab commented May 1, 2015

The goal of this issue is to improve user experience and speed in the particular (#6759) use case of a large date range over many years and loading a flattened report.

Currently in the example below:

  • first load takes 45 seconds (on first load it will archive the data + display it)
  • subsequent loads take 7 seconds (data is archived, just display it)

Reproduce:

  • the date range was over 5 years old: date=2009-05-02,2015-05-01&period=range.
  • demo URL

Ideally Piwik should archive data + display it under 10 seconds instead of 45 for a typical medium traffic website like piwik.org. Subsequent page load ideally should load in 1-2 seconds instead of 7.
How would it be possible?

we'll need to get creative, and some tools, ☕ and a profiler

@mattab mattab added Task Indicates an issue is neither a feature nor a bug and it's purely a "technical" change. c: Performance For when we could improve the performance / speed of Matomo. labels May 1, 2015
@mattab mattab modified the milestone: Short term May 1, 2015
@gaumondp
Copy link

gaumondp commented May 1, 2015

Serious question: What is a "medium traffic website" for you/Piwik ?

In Piwik's world, "medium traffic" means 5k to 10k pageviews/day ? Piwik's own site had 3000 pageviews /daymax last month.

Do my 90k pageviews a day installation worth "high traffic website" moniker ?

@mattab
Copy link
Member Author

mattab commented May 2, 2015

90k pages per day, ~ 3M per month, is considered high traffic

@mattab
Copy link
Member Author

mattab commented Jul 15, 2015

On demo.piwik.org today, loading the page took 25 seconds. Looks like we improved compared to May where it took 45 seconds to load the page.

@mattab mattab added this to the Mid term milestone Jul 15, 2015
@mattab mattab modified the milestones: Long term, Mid term Dec 5, 2016
@mattab
Copy link
Member Author

mattab commented Dec 14, 2023

Thanks for your patience with this issue. We believe this has been resolved in the recent updates of Matomo. To ensure you have the fix, please update to the latest version of Matomo. If the issue persists after the update, don't hesitate to reopen this issue and let us know. Cheers!

@mattab mattab closed this as not planned Won't fix, can't repro, duplicate, stale Dec 14, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
c: Performance For when we could improve the performance / speed of Matomo. Task Indicates an issue is neither a feature nor a bug and it's purely a "technical" change.
Projects
None yet
Development

No branches or pull requests

2 participants