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 _______________________________________________ Monotone-devel mailing list Monotone-devel@nongnu.org http://lists.nongnu.org/mailman/listinfo/monotone-devel