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

User profile slowness in getAdjacentVisitorId() #4296

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

User profile slowness in getAdjacentVisitorId() #4296

mattab opened this issue Nov 13, 2013 · 4 comments
Assignees
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Milestone

Comments

@mattab
Copy link
Member

mattab commented Nov 13, 2013

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
Copy link
Member

tsteur commented Nov 13, 2013

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

@tsteur
Copy link
Member

tsteur commented Nov 13, 2013

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

@tsteur
Copy link
Member

tsteur commented Nov 13, 2013

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

@tsteur
Copy link
Member

tsteur commented Nov 13, 2013

In 57ee4b4: refs #4296 do not set timezone

@mattab mattab added this to the 2.0 - Piwik 2.0 milestone Jul 8, 2014
sabl0r pushed a commit to sabl0r/piwik that referenced this issue Sep 23, 2014
sabl0r pushed a commit to sabl0r/piwik that referenced this issue Sep 23, 2014
sabl0r pushed a commit to sabl0r/piwik that referenced this issue Sep 23, 2014
sabl0r pushed a commit to sabl0r/piwik that referenced this issue Sep 23, 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

2 participants