matomo-org / matomo

Empowering People Ethically with the leading open source alternative to Google Analytics that gives you full control over your data. Matomo lets you easily collect data from websites & apps and visualise this data and extract insights. Privacy is built-in. Liberating Web Analytics. Star us on Github? +1. And we love Pull Requests!
https://matomo.org/
GNU General Public License v3.0
19.7k stars 2.62k forks source link

Provide a way to cancel queries running #9769

Open gaumondp opened 8 years ago

gaumondp commented 8 years ago

When switching from a small site report to the All Websites pages, it's possible to make Piwik overload and unresponsive. We should have some kind of "stop all queries" / "panic button" available.

Use case : On a small site I had a Date range Jan 2014-November 2015, 10k visits but once done with it clicked on "All Websites". Piwik keeps the Date Range (that's expected) but with 80 millions lines in my Piwik DB and just 15 sites, Piwik became unresponsive. I closed the page and login back but it took 3 minutes to finally have something showed (I login to "today" by default).

tsteur commented 8 years ago

This would be ideal for a new plugin. Maybe someone from the community is keen to work on it and to publish it on the Marketplace?