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

Performance: Denormalize one logging table #2002

Closed
mattab opened this issue Jan 11, 2011 · 2 comments
Closed

Performance: Denormalize one logging table #2002

mattab opened this issue Jan 11, 2011 · 2 comments
Assignees
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Milestone

Comments

@mattab
Copy link
Member

mattab commented Jan 11, 2011

This will be a strong Archiving performance improvement: denormalize log_link_visit_action by adding idsite,time fields and INDEX. Update Pages archiving to remove the JOIN. Enjoy much better performance :)

@mattab
Copy link
Member Author

mattab commented Jan 12, 2011

(In [3714]) Fixes #2002 nice!

@mattab
Copy link
Member Author

mattab commented Jan 16, 2011

(In [3753]) Refs #2002 Fixing few bugs after refactoring / performance improvements, triggered when a visit overlaps 2 days

  • adding integration tests for this use case
  • Also testing for empty URL and empty page name
  • Exit page name consistent with Exit page URL

@mattab mattab added this to the Piwik 1.2 milestone Jul 8, 2014
@mattab mattab self-assigned this Jul 8, 2014
This issue was closed.
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.
Projects
None yet
Development

No branches or pull requests

1 participant