Re: [Tracker] ANNOUNCE: tracker 0.6.91 released

[Jamie McCracken <jamie mccrack googlemail com>]

On Sat, 2009-03-14 at 18:32 +0100, JÃrg Billeter wrote:
> On Sat, 2009-03-14 at 11:18 -0400, Jamie McCracken wrote:
> > yeah I dont know why they replaced the fast summarised stats with a real
> > time count which is way too slow
> >
> > martyn can you revert that bit?
> >
> > doing a count with group by will involve a full table scan which would
> > be especially bad with the decomposed branch
>
> In the decomposed branch we can use COUNT(*) on each class table, this
> should be fast and not require grouping.

but for stats we want it grouped

I mean its ok if you just want the number of music files but not it you
want summarised stats for everything (which is what the applet displays)

jamie