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

[Danielle Madeley]

On Mon, 2010-03-15 at 03:31 +0100, Ivan Vučica wrote:
> Why not SQLite, as proposed in 4)? Log data can always be easily  
> dumped into XML if deemed necessary, but this way it's perhaps more  
> easily searchable and filtered? E.g. "grab all data generated by pecan  
> between 1am and 2am today". "Return per-hour message count stats for  
> gabble and pecan".

So we're now using Sqlite to generate lists of most frequent contacts
etc. and for journalling incoming messsages, so I thought I'd profile
using it for the entire message store.

Attached is the test, and performance graph for a variety of different
SELECTs the log backend is likely to do.

This is a bit simplified, but should be demonstrative. Really to test it
further, we need to see how it scales to something like #ubuntu. Also, I
am not really an SQL master, so there may be improvements.

Graph and test attached.

--danni

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

www.collabora.co.uk
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sqlite-performance.png
Type: image/png
Size: 55763 bytes
Desc: not available
URL: <http://lists.freedesktop.org/archives/telepathy/attachments/20100315/6525468f/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sqlite-performance.c
Type: text/x-csrc
Size: 7081 bytes
Desc: not available
URL: <http://lists.freedesktop.org/archives/telepathy/attachments/20100315/6525468f/attachment-0001.c>