Comment 75 for bug 280958

Thanks Rob - it's been a huge collaborative effort as you can see in the comments.

The reason for using soyuz-specific karma is that it is the easiest - we can use it in the query via a single join without any aggregations etc., This is because we have a KarmaCache (updated daily) which stores a person's total karma for a particular karma category ('soyuz'), distribution and package name.

If it makes more sense to favour devs for these related PPAs, we could instead use the 'code' karma category and order by the person's total code-karma for the product/project? (still without doing aggregates etc.)

And finally, if it was worthwhile and we had a good heuristic, we could *try* to use some kind of aggregate (sum/avg?) of karma across multiple categories, but that will require quite an ugly query (due to the different ways karma can be recorded - against packages/projects/products).

Either way, we'll still need to watch the current ordering over the next few days - it might favour people who regularly grab FF3.5 and upload it to their own PPA too strongly.