[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?
Chad