Opened 3 years ago

Closed 3 years ago

#1966 closed Bug (fixed)

Live! plugin performance issues

Reported by: matt Owned by: matt
Priority: critical Milestone: Piwik 1.3
Component: Core Keywords:
Cc: Sensitive: no

Description

See report in : http://forum.piwik.org/read.php?2,70690

The query should have AND visit_last_action_time > ?

clause to make it use the INDEX and perform better.

Change History (10)

comment:1 Changed 3 years ago by bugmenot

I have this problem too. piwik has become unusable since the critical update from 1.0.

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

(In [3758]) Refs #1966 Spy should not keep doing requests when the screen is not showing the widget anymore

comment:3 Changed 3 years ago by fil

Piwik was very slow for me and unusable; disabling "Live!" made it usable again.

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

  • Priority changed from normal to critical

we must take a decision: either we disable Live! by default for all new installs, or we fix these performance issues

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

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

I fixed this issue, just and introduced a new bug tracked in: http://dev.piwik.org/trac/ticket/2076#comment:3

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

  • Milestone changed from Piwik 1.2 to 1.3 - Piwik 1.3
  • Resolution fixed deleted
  • Status changed from closed to reopened

this obviously wasn't fixed properly

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

  • Owner set to matt
  • Status changed from reopened to new

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

(In [4316]) Fixes #2145 as far as I can see, it should be fixed, but I've been wrong all previous times so testing is very much welcome! thx

Refs #1966 Improving visitor log performance by rewriting the query

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

(In [4317]) Fixes #2259 Kuddos SteveG for spotting this issue!

Refs #1966 cancel the other ajax request as well, when something wrong happened in the previous request + fixing the missing order by

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

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

wow that looks fast now!! Will keep an eye on it

Note: See TracTickets for help on using tickets.