TOFU performance / DB format
wk at gnupg.org
Fri Oct 23 21:10:41 CEST 2015
On Fri, 23 Oct 2015 19:09, neal at walfield.org said:
> In 7f65e84, I added an interface to enable batch updates. This was
> based on the observation that SQLite performs better when there is a
> single big transaction instead of many small transactions . This
I have not looked at the patch but I assume that you now do a
BEGIN_TRANSACTION and a single COMMIT at the end of the key listing
instead of the default auto-commit mode. Given that this is now a
single large transaction, I wonder how the system behaves if several
gpg instances start a Key listing at about the same time.
Kleopatra is known for doing this in some cases.
> $ rm -rf tofu.d*; time gpg2 --trust-mode=tofu --tofu-db-format=flat -k >/dev/null
> real 0m0.161s
> user 0m0.052s
> sys 0m0.004s
Now many keys?
Die Gedanken sind frei. Ausnahmen regelt ein Bundesgesetz.
More information about the Gnupg-devel