User profile slowness in getAdjacentVisitorId() #4296

Closed
mattab opened this Issue Nov 13, 2013 · 4 comments

2 participants

@mattab
Piwik Open Source Analytics member

We noticed on the demo that after deploying 2.0-b3, there is some slowness in getAdjacentVisitorId(). This feature is used in the Visitor profile to get the Previous/Next visitor.

Instead of running a separate SQL query maybe this getAdjacentVisitorId() method should reuse getLastVisitsDetails?

@tsteur
Piwik Open Source Analytics member

In 484801d: refs #4296 this could improve performance of getting next / prev visitor info

@tsteur
Piwik Open Source Analytics member

In 713e8a5: refs #4296 only search for prev/next visitor one day in the past and future

@tsteur
Piwik Open Source Analytics member

In 5e0f920: refs #4296 take the sites timezone into consideration

@tsteur
Piwik Open Source Analytics member

In 57ee4b4: refs #4296 do not set timezone

@mattab mattab added this to the 2.0 - Piwik 2.0 milestone Jul 8, 2014
@tsteur tsteur was assigned by mattab Jul 8, 2014
@sabl0r sabl0r pushed a commit to sabl0r/piwik that referenced this issue Sep 23, 2014
@tsteur tsteur refs #4296 this could improve performance of getting next / prev visi…
…tor info
484801d
@sabl0r sabl0r pushed a commit to sabl0r/piwik that referenced this issue Sep 23, 2014
@tsteur tsteur refs #4296 only search for prev/next visitor one day in the past and …
…future
713e8a5
@sabl0r sabl0r pushed a commit to sabl0r/piwik that referenced this issue Sep 23, 2014
@tsteur tsteur refs #4296 take the sites timezone into consideration 5e0f920
@sabl0r sabl0r pushed a commit to sabl0r/piwik that referenced this issue Sep 23, 2014
@tsteur tsteur refs #4296 do not set timezone 57ee4b4
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment