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.

Sign up for GitHub

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

Jump to bottom

Why u guys use a frequently update column as part of an index? #2272

Closed
anonymous-matomo-user opened this issue Apr 6, 2011 · 2 comments
Closed

Why u guys use a frequently update column as part of an index? #2272

anonymous-matomo-user opened this issue Apr 6, 2011 · 2 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc. worksforme The issue cannot be reproduced and things work as intended.
Milestone
1.3

Comments

@anonymous-matomo-user
Copy link

Hey guys,
I noticed there are two indexes on table piwik_log_visit which contain a common column, namely visit_last_action_time, which is a frequently updated column, why not use visit_first_action_time instead?
@robocoder
Copy link
Contributor

Because we use visit_last_action_time in WHERE and ORDER BY clauses.

@robocoder
Copy link
Contributor

p.s. in future, please use the forum for questions. We prefer to use Trac for bug reports, patches, and development planning (e.g., roadmap for feature requests).

@anonymous-matomo-user anonymous-matomo-user added this to the Piwik 1.3 milestone 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
Assignees
No one assigned
Labels
Bug For errors / faults / flaws / inconsistencies etc. worksforme The issue cannot be reproduced and things work as intended.
Projects
None yet
Milestone
1.3
Development

No branches or pull requests
3 participants
@mattab @robocoder @anonymous-matomo-user