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

Make transitions faster for all Piwik users: add more INDEX to database #9276

Closed
mattab opened this issue Nov 25, 2015 · 2 comments
Closed

Make transitions faster for all Piwik users: add more INDEX to database #9276

mattab opened this issue Nov 25, 2015 · 2 comments
Labels
c: Performance For when we could improve the performance / speed of Matomo. not-in-changelog For issues or pull requests that should not be included in our release changelog on matomo.org.
Milestone
3.0.0-b1

Comments

@mattab
Copy link
Member

mattab commented Nov 25, 2015

Goal of this issue is that, for new Piwik users, we should add more INDEX to the database schema, in order to make Transitions very fast to render.

This issue has been documented for years in the Piwik FAQ: How do I make “Transitions” feature work faster on high traffic websites?

But it is uncomfortable situation for users:

  • one has to notice transitions is slow (which is annoying and bad user experience)
  • one has to think "maybe there is a solution to make this faster?"
  • then one has to look in FAQ and find this one: https://piwik.org/faq/how-to/faq_161/
  • then one has to ask sysadmin to execute long and cumbersome SQL queries (that can take hours or days on big databases)

By adding these INDEX for New users in Piwik, we will prevent this issue forever.

For existing Piwik users, we need to decide if:

  • we add the INDEX during the upgrade to 3.0.0 (recommended!)
  • or instead we could add a System check entry "Has the transitions INDEX been setup?" or so
@mattab mattab added the c: Performance For when we could improve the performance / speed of Matomo. label Nov 25, 2015
@mattab mattab added this to the 3.0.0-b1 milestone Nov 25, 2015
@mattab mattab mentioned this issue Nov 25, 2015
Closed
@theyosh
Copy link
Contributor

theyosh commented Nov 28, 2015

Hi,

as adding indexes will take a lot of time if you have a big database, this should not be applied automatically. Adding indexes can always be done afterwards. Without the indexes it still works, but slow. So the system is not hanging or not working without the indexes. It is just slow.

As I have a large setup, I would like to execute the index SQL statements through console. And also when it suits me. So I would add this information, and the SQL statement somewhere in a system overview page.

For new setups, just add the indexes to the install SQL file.

@tsteur
Copy link
Member

tsteur commented Sep 13, 2016

As discussed closing this issue as it is not super slow for most sites but would make tracking slower. FAQ explains how to add the indexes if there are problems. We might reopen this later and add the indexes

@tsteur tsteur closed this as completed Sep 13, 2016
@tsteur tsteur added the not-in-changelog For issues or pull requests that should not be included in our release changelog on matomo.org. label Sep 13, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
c: Performance For when we could improve the performance / speed of Matomo. not-in-changelog For issues or pull requests that should not be included in our release changelog on matomo.org.
Projects
None yet
Milestone
3.0.0-b1
Development

No branches or pull requests
3 participants
@tsteur @mattab @theyosh