Performance: Denormalize one logging table #2002

mattab opened this Issue Jan 11, 2011 · 2 comments

1 participant

Piwik Open Source Analytics member

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 :)

Piwik Open Source Analytics member

(In [3714]) Fixes #2002 nice!

Piwik Open Source Analytics member

(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