[Foundation-l] preferences statistics

Andrew Garrett agarrett at wikimedia.org
Wed Nov 10 00:09:51 UTC 2010


On Tue, Nov 9, 2010 at 6:44 PM, Ashar Voultoiz <hashar+wmf at free.fr> wrote:
> On 02/11/10 15:03, Andrew Garrett wrote:
> <snip>
>> If you wrote it before I rewrote the preferences system in 2009, then
>> it is out of date.
>
> Since it use the internal abstraction layer, I would expect it to still
> be working.

Ah, then it will probably be hopelessly inefficient. You should just
use a query like this:

SELECT up_property,up_value,count(*) FROM user_properties GROUP BY
up_property,up_value;

-- 
Andrew Garrett
http://werdn.us/



More information about the foundation-l mailing list