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.57k stars 2.61k forks source link

Action datatables should use integer indexes rather than string indexes (smaller size and faster access) #1600

Closed mattab closed 13 years ago

mattab commented 14 years ago

Currently datatables for Actions are indexed with the metrics string (nb_visits, nb_hits, etc.). See code in plugins/Actions/Actions.php archiveDay()

Other datatables are using integer indexes, mapping is defined in Piwik_Archive::$mappingFromIdToName

Actions datatable should use a similar integer mapping to reduce size of Actions datatables, and make querying faster.

mattab commented 13 years ago

thanks to halfdan run of xhprof, we now know that this is indeed very costly, lets fix it

mattab commented 13 years ago

(In [3696]) Page titles report improvements fixes #1898

Performance improvements

Improvements to integration tests