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

Reuse existing period archives when range date is requested when possible #12004

Merged
merged 1 commit into from Sep 18, 2017

Conversation

tsteur
Copy link
Member

@tsteur tsteur commented Sep 5, 2017

fixes #12003
Did a simple test locally. Without this patch I see no data, with patch I see existing data from eg a week archive.

Not sure if this would have any downsides but can't think of any.

@tsteur tsteur added 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. labels Sep 5, 2017
@tsteur tsteur added this to the 3.2.0 milestone Sep 5, 2017
@tsteur
Copy link
Member Author

tsteur commented Sep 5, 2017

Actually, there is an index on period which is why the period = ? is there I think but the index already matches the first three columns of the index

(`idsite`,`date1`,`date2`,`period`,`ts_archived`)

so it should be fine I think and still fast

@mattab
Copy link
Member

mattab commented Sep 18, 2017

Also can't think of a downside, considering the INDEX would still be used.

Nice idea 👍

@mattab mattab merged commit 5e11988 into 3.x-dev Sep 18, 2017
@mattab mattab deleted the 12003 branch September 18, 2017 03:27
mattab added a commit that referenced this pull request Sep 18, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
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
Development

Successfully merging this pull request may close these issues.

Range period should use existing archives of week/month/year periods if possible
2 participants