diff options
| author |   schwarze <schwarze@openbsd.org> | 2014-01-17 19:07:12 +0000 |
|---|---|---|
| committer | schwarze <schwarze@openbsd.org> | 2014-01-17 19:07:12 +0000 |
| commit | bb153e36e7d760b288a039eb4eeee7fa25f4bf9f (patch) | |
| tree | ff641c87013be37bd6126b7e47f0ae7cdd91c9a6 | |
| parent | ctype and other sign extension fixes. (diff) | |
| download | wireguard-openbsd-bb153e36e7d760b288a039eb4eeee7fa25f4bf9f.tar.xz wireguard-openbsd-bb153e36e7d760b288a039eb4eeee7fa25f4bf9f.zip | |
Despite some experimenting, i'm unable to find any relevant effect of
creating an index for the keys table on apropos(1) search times;
apparently, adding that index was premature optimization in the first
place; so, stop adding that index.
Its root gone, the following evil is reduced (/usr/share/man on my notebook)
- DB build time with -Q goes down by 15%, now at 1/3 of makewhatis
- DB size with -Q goes down by 35%, now at 3.5x of makewhatis
- full DB build time goes down by 12%, now at 2.1x of makewhatis
- full DB size goes down by 42%, now at 11.5x of makewhatis
Optimization found somewhere above the Dasht-e Kavir, the Great Salt
Desert, between Tehran (Iran) and Herat (Afghanistan). Committing
from Melbourne, Australia.
| -rw-r--r-- | usr.bin/mandoc/mandocdb.c | 6 |
1 files changed, 2 insertions, 4 deletions
diff --git a/usr.bin/mandoc/mandocdb.c b/usr.bin/mandoc/mandocdb.c index 4db117d7f23..42de78fd9b5 100644 --- a/usr.bin/mandoc/mandocdb.c +++ b/usr.bin/mandoc/mandocdb.c @@ -1,4 +1,4 @@ -/* $Id: mandocdb.c,v 1.64 2014/01/06 20:53:36 schwarze Exp $ */ +/* $Id: mandocdb.c,v 1.65 2014/01/17 19:07:12 schwarze Exp $ */ /* * Copyright (c) 2011, 2012 Kristaps Dzonsons <kristaps@bsd.lv> * Copyright (c) 2011, 2012, 2013, 2014 Ingo Schwarze <schwarze@openbsd.org> @@ -1916,9 +1916,7 @@ dbopen(int real) " \"pageid\" INTEGER NOT NULL REFERENCES mpages(id) " "ON DELETE CASCADE,\n" " \"id\" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL\n" - ");\n" - "\n" - "CREATE INDEX \"key_index\" ON keys (key);\n"; + ");\n"; if (SQLITE_OK != sqlite3_exec(db, sql, NULL, NULL, NULL)) { exitcode = (int)MANDOCLEVEL_SYSERR; |