]> git.evergreen-ils.org Git - Evergreen.git/commit
projects / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: d9a4c83) | patch
LP#783486: Improve authority lookup performance
authorDan Scott <dan@coffeecode.net>
Tue, 17 May 2011 04:29:47 +0000 (00:29 -0400)
committerDan Scott <dan@coffeecode.net>
Tue, 17 May 2011 04:29:47 +0000 (00:29 -0400)
commitd6f8124b33f738bd06e0e83f7b2ba815ad3165bf
treeeb6baa4ba6f226dd963dabc1a1509b6fbf139f71tree
parentd9a4c8382cb65b36f201f12a7b06b32a3fc953c8commit | diff
LP#783486: Improve authority lookup performance

Testing showed that the two indexes added herein improve
authority lookup performance radically; on a 16 GB RAM
database server with 1.1M records, lookup times decreased
from 5500 ms to 0.223 ms. Recommended, would EXPLAIN ANALYZE
again.

Signed-off-by: Dan Scott <dan@coffeecode.net>
Open-ILS/src/sql/Pg/002.schema.config.sql diff | blob | history
Open-ILS/src/sql/Pg/011.schema.authority.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/0535.schema.authority_indexes.sql [new file with mode: 0644] blob
Evergreen ILS