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

Tracking API: major performance improvements with Transactions, when using Bulk Tracking #5275

Closed
mattab opened this issue Jun 2, 2014 · 1 comment
Closed

Tracking API: major performance improvements with Transactions, when using Bulk Tracking #5275

mattab opened this issue Jun 2, 2014 · 1 comment
Assignees
@mattab
Labels
c: Performance For when we could improve the performance / speed of Matomo. Task Indicates an issue is neither a feature nor a bug and it's purely a "technical" change.
Milestone
2.4.0

Comments

@mattab
Copy link
Member

mattab commented Jun 2, 2014

By wrapping our Bulk Tracking API requests within a transaction, speed of Tracking API will greatly increase. This is because with Mysql innodb tables, the index will be written only once after all requests have been imported!

This was suggested in this pull request: #281

This change results in massive performance improvements for
@mattab
Copy link
Member Author

mattab commented Jun 2, 2014

In 657a35e: Merge pull request #281 from medic123de/db-transactional-mode

Use transactions for Tracking API requests in bulk. fixes #5275

Thanks for the pull request, it's an Awesome Performance Improvement!

@mattab mattab added this to the 2.4.0 - Piwik 2.4.0 milestone Jul 8, 2014
@mattab mattab self-assigned this 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

@mattab mattab

Labels
c: Performance For when we could improve the performance / speed of Matomo. Task Indicates an issue is neither a feature nor a bug and it's purely a "technical" change.
Projects
None yet
Milestone
2.4.0
Development

No branches or pull requests
1 participant
@mattab