Re: [Tracker] How to reduce meta.db file size?

[Martyn Russell <martyn lanedo com>]

On 15/06/11 15:53, Philip Van Hoof wrote:
> On Wed, 2011-06-15 at 14:57 +0100, Lionel Landwerlin wrote:
> > Hi Simon,

Hi all,

> > I would be interested in responses to that problem too.
> > I'm more interested in the growing database problem when you remove and
> > add files :
>
> > https://bugzilla.gnome.org/show_bug.cgi?id=645046
>
> We plan to start working on this problem in a few weeks. Our current
> idea is to create a journal format to make a periodic sort of copy of
> meta.db as a snapshot.
>
> That copy of meta.db would then be used as a starting point for the
> normal journal to be appended to when replaying.
>
> Then periodically, or at a certain journal size, would this snapshot be
> made and would the normal journal be truncated (restarted).
>
> Deleted content isn't in meta.db, so not copied to the snapshot. In the
> normal journal - part deleted content would still be there, but that
> will be periodically truncated.
>
> Anyway, these are just ideas at the moment. But we're planning to work
> on a solution soon.

Philip, it is probably worth pointing out that this is unlikely to hit 
0.10.x (unless there's been some change in the ideas here since I last 
looked at them).

--
Regards,
Martyn

Founder and CEO of Lanedo GmbH.