"Ranking Query" to decrease archiving memory consumption and transfered data between MySQL and PHP
|Reported by:||EZdesign||Owned by:||capedfuzz|
|Priority:||major||Milestone:||2.x - The Great Piwik 2.x Backlog|
Based on the discussions in #766, this ticket is the place for code that limits the number of results returned from MySQL.
The idea is to create a class that wraps an arbitrary SQL query with more SQL that limits the number of results while grouping the rest to "Others" and allows for some more fancy things that can be configured via an instance of the ranking query class.
Change History (26)
comment:6 Changed 20 months ago by matt (mattab)
- Milestone changed from 1.8.x - Piwik 1.8.x to 1.8.4 - Piwik 1.8.4
comment:22 Changed 18 months ago by matt (mattab)
- Milestone changed from 1.9.2 - Piwik 1.9.2 to 1.x - Piwik 1.x