[Telepathy] thinking about a new log format for telepathy-logger

[Danielle Madeley]

On Mon, 2010-03-15 at 13:29 +0100, Ivan Vučica wrote:

>  Interesting graph! I'm not an SQL master either, and I don't know
> about internals of SQLite, but it sounds to me like that DISTINCT in
> get-dates might be attempting to filter out every single date, but
> without help of an index. May I humbly suggest this index:
> (account, id, date)
> After filtering by account and id in WHERE statement, this should
> provide everything sorted by date, and somewhat more easily filterable
> for unique dates.

The problem is that it's a timestamp. It would be possible to split the
timestamp up into a separate date and time, so that you can index the
date. That's probably worth testing.


-- 
Danielle Madeley
Software Developer, Collabora Ltd.                  Melbourne, Australia

www.collabora.co.uk