Opened 3 years ago

Closed 3 years ago

Last modified 3 years ago

#2002 closed Bug (fixed)

Performance: Denormalize one logging table

Reported by: matt Owned by: matt
Priority: normal Milestone: Piwik 1.2
Component: Core Keywords:
Cc: Sensitive: no

Description

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

Change History (2)

comment:1 Changed 3 years ago by matt (mattab)

  • Resolution set to fixed
  • Status changed from new to closed

(In [3714]) Fixes #2002 nice!

comment:2 Changed 3 years ago by matt (mattab)

(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


Note: See TracTickets for help on using tickets.