Navigation Menu

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

Jump to bottom

Performance & Scalability improvements in Piwik: ideas to research #1999

Closed
mattab opened this issue Jan 11, 2011 · 5 comments
Closed

Performance & Scalability improvements in Piwik: ideas to research #1999

mattab opened this issue Jan 11, 2011 · 5 comments
Labels
answered For when a question was asked and we referred to forum or answered it. 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
Long term

Comments

@mattab
Copy link
Member

mattab commented Jan 11, 2011

From #386, some ideas we gathered that could potentially improve Piwik performance and scalability:

Algorithms

Other performance related tickets are: #409, #5, #134, #766, #1077, #3126
@mattab
Copy link
Member Author

mattab commented Jan 15, 2011

I tried to use json as a replacement, but forgot that we serialize objects... so it doesn't work


Recoverable Error: Argument 1 passed to Piwik_DataTable::addRow() must be an instance of Piwik_DataTable_Row, instance of stdClass given, called in trunk\core\DataTable.php on line 996 and defined in trunk\core\DataTable.php on line 497

For the record I attach the patch.

So to use JSON, we should create the DataTable when loading the blob. This is doable, just a bit more work. Definitely worth testing more.

@mattab
Copy link
Member Author

mattab commented Jan 20, 2011

  • Could we get rid of the idlink_va primary key in the log_link_visit_action table? it is useless as it is, appart from the practicality that it auto increments. We could put up the primary key as compound index.

@anonymous-matomo-user
Copy link

The MongoDB way would definitely be interesting. Is it still an active topic ?

@mattab
Copy link
Member Author

mattab commented Apr 4, 2011

It is still an active topic of discussion and brainstorming, but we haven't scheduled any work, besides issues and pull requests linked below.

If you have knowledge and are a developer, feel free to experiment or work with us, it would be great!

@mattab mattab added this to the 2.x - The Great Piwik 2.x Backlog milestone Jul 8, 2014
This was referenced Dec 14, 2012
Closed
Closed
@mattab mattab removed the Major label Aug 3, 2014
@mattab mattab mentioned this issue Dec 1, 2014
Closed
@mattab mattab mentioned this issue Mar 24, 2015
Closed
@mattab
Copy link
Member Author

mattab commented May 1, 2015

Marking this meta issue closed as topics are now covered in separate issues and there are quite a few issues & good ideas tagged with Performance label.

@mattab mattab closed this as completed May 1, 2015
@mattab mattab added the answered For when a question was asked and we referred to forum or answered it. label May 1, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
answered For when a question was asked and we referred to forum or answered it. 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
Long term
Development

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