[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Monotone-devel] Monotone speedup by adding additional database indi
Re: [Monotone-devel] Monotone speedup by adding additional database indices?
Wed, 10 Oct 2007 14:52:38 -0500
> 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%!
> 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?