On Mon, 2009-03-16 at 13:57 +0100, Jürg Billeter wrote: > 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. >
AFAIK only mysql is optimised for row counts as it stores it in the header of the table. Im not aware sqlite stores row counts. The actual counting is not so much a concern if its a one time affair (IE only ever done once per session) jamie _______________________________________________ tracker-list mailing list tracker-list@gnome.org http://mail.gnome.org/mailman/listinfo/tracker-list
