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

[Chad Walstrom]

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?

Chad