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

API Performance improvements on very large setup: SQL query tweak #3140

Closed
mattab opened this issue May 9, 2012 · 4 comments
Closed

API Performance improvements on very large setup: SQL query tweak #3140

mattab opened this issue May 9, 2012 · 4 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Milestone

Comments

@mattab
Copy link
Member

mattab commented May 9, 2012

See in forum

We could change the archive select sql query to make it faster and use an index instead of memory sort.

@diosmosis
Copy link
Member

Attachment: Benchmarking patch.
3140.diff.tar.gz

@diosmosis
Copy link
Member

Been looking into this issue. I created a benchmarking system to test the changes I made. However, there doesn't seem to be any change in speed when applying the changes SQL changes specified in the forum... Maybe I'm not adding enough data?

@mattab
Copy link
Member Author

mattab commented May 24, 2012

Nice that you investigate this one, it's not easy to reproduce such issues indeed.

  • Did you try on mysql 5.5.x ?
  • in the bug report the user had about 1M rows in the tables, so maybe the bug shows up with more?
  • Also you can try changing the tables to InnoDB which might be one factor playing a role in this regression?

@mattab
Copy link
Member Author

mattab commented May 30, 2012

(In [6402]) Fixes #3140 Can it really be that simple??

@mattab mattab added this to the Piwik 1.8 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
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Projects
None yet
Development

No branches or pull requests

2 participants