Re: [Tracker] Performance improvement for tracker-0.6

[Martyn Russell <martyn imendio com>]

On Thu, 2009-05-14 at 18:48 +0200, Carlos Garnacho wrote:
> Here's an updated version, basically it moves table data handling to
> libtracker-data (by introducing a TrackerDataUpdateMetadataContext
> object), and adds support for initial insertions into the DB, instead of
> doing 1 insertion and N updates.
>
> On jue, 2009-05-14 at 16:54 +0200, Philip Van Hoof wrote:
> > On Thu, 2009-05-14 at 16:19 +0200, Philip Van Hoof wrote:
> >
> > > This is a performance improvement in how tracker-0.6 uses SQLite.
> > >
> > > Instead of having many UPDATE statements per created resource this tries
> > > to combine them together into one larger UPDATE statement.
> >
> >
> > +       if (!error) {
> > +               g_warning ("%s", error->message);
> > +               g_clear_error (&error);
> > +       }
> >
> > This is of course wrong, should be "if (error)" instead.

Thanks Carlos and Philip.

I committed Carlos' patch. On my desktop, this changes the indexing
speed for 7k items from 35 seconds down to 28 seconds.

We are also working on a solution next week which uses
journal_mode=MEMORY. When using this with the patch just committed, it
takes 23 seconds to index my content.

-- 
Regards,
Martyn