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

Jump to bottom

Tweak live queries when they query current week, month, or year where end date is in the future #14759

Merged
merged 1 commit into from Aug 16, 2019
Merged

Tweak live queries when they query current week, month, or year where end date is in the future #14759

merged 1 commit into from Aug 16, 2019

Conversation

tsteur
Copy link
Member

@tsteur tsteur commented Aug 12, 2019

To make use of the query performance tweak we added in #14700

Otherwise we query eg

2019-12-30-2019-12-31
then 2019-12-23-2019-12-30
then 2019-11-23-2019-12-23
then the rest of the year

instead of say

2019-08-12 - 2019-08-11
2019-08-04 - 2019-08-11
...

if today was 2019-08-12 preventing full table scans

@tsteur tsteur added not-in-changelog For issues or pull requests that should not be included in our release changelog on matomo.org. Needs Review PRs that need a code review labels Aug 12, 2019
@tsteur tsteur added this to the 3.12.0 milestone Aug 12, 2019
@diosmosis diosmosis merged commit 9ed5c2c into 3.x-dev Aug 16, 2019
@diosmosis diosmosis deleted the visitorlogtweak branch August 16, 2019 01:42
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers
No reviews
Assignees
No one assigned
Labels
Needs Review PRs that need a code review not-in-changelog For issues or pull requests that should not be included in our release changelog on matomo.org.
Projects
None yet
Milestone
3.12.0
Development

Successfully merging this pull request may close these issues.

None yet
2 participants
@tsteur @diosmosis