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

New setting to disable processing of unique visitors for segments #9832

Open
mattab opened this issue Feb 23, 2016 · 1 comment
Open

New setting to disable processing of unique visitors for segments #9832

mattab opened this issue Feb 23, 2016 · 1 comment
Labels
c: Performance For when we could improve the performance / speed of Matomo. Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc.

Comments

@mattab
Copy link
Member

mattab commented Feb 23, 2016

Problem

When a Piwik has thousands of segments created, a clear bottleneck is that processing unique visitors and unique users for a period such as week, month, year is very slow. The query to process unique visitors over a week often lasts more than 20 minutes. This is problematic when there are thousands such queries running every day.

Proposal

As a solution, we could add a new setting enable_processing_unique_visitors_segments which, when set to 0, would disable unique visitors processing for segments.

We may also want to create more specific settings to disable processing of unique for segments, for a particular period:

enable_processing_unique_visitors_segments_day
enable_processing_unique_visitors_segments_week
enable_processing_unique_visitors_segments_month
enable_processing_unique_visitors_segments_year
@tsteur
Copy link
Member

tsteur commented Feb 23, 2016

Please let's either add enable_processing_unique_visitors_segments or the others but not both. There's already enough complexity added through all those config settings so we don't have to make it even more complex and harder to understand.

@mattab mattab added this to the 2.16.x (LTS) milestone Mar 31, 2016
@mattab mattab added Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc. c: Performance For when we could improve the performance / speed of Matomo. labels Mar 31, 2016
@mattab mattab modified the milestones: Long term, 2.16.x (LTS) Aug 23, 2016
@mattab mattab modified the milestones: Long term, Mid term Dec 5, 2016
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. Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc.
Projects
None yet
Development

No branches or pull requests

2 participants