Re: [Tracker] ANNOUNCE: tracker 0.6.91 released

[Jürg Billeter <j bitron ch>]

On Sat, 2009-03-14 at 14:03 -0400, Jamie McCracken wrote:
> 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)

We will obviously need the row count of each class table, not just one.
This should still be fast, though, as SQLite can return the row count of
each table without reading any actual data in the table, as far as I
know.

JÃrg