[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Monotone-devel] Monotone speedup by adding additional database indi

From: Chad Walstrom
Subject: Re: [Monotone-devel] Monotone speedup by adding additional database indices?
Date: Wed, 10 Oct 2007 14:52:38 -0500

Ralph wrote:
>   CREATE INDEX revision_certs__id_name_value ON
>                revision_certs (id, name, value);
>   CREATE INDEX public_keys__id ON
>                public_keys (id);
> This dropped down the total execution time of the mentioned "mtn update"
> command by over 80%!

Ben wrote:
> Indexes speed up read operations but slow down writes.

I can't imagine a lot of writes happening to public_keys. ;-)
revision_certs would get four or more inserts per commit, and obviously
sync operations would add a bunch.  Commits have generally been pretty
fast for me.  Would there be a way to tell sqlite to ignore indices for
given operations, such as pulls?


reply via email to

[Prev in Thread] Current Thread [Next in Thread]