]> git.evergreen-ils.org Git - Evergreen.git/commit
projects / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: b3bedbd) | 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:53:50 +0000 (00:53 -0400)
commit02b6bc50ae6df2ea06cede9f77f88dc1a074bf0c
treee30de39f50b95d0ba6653d6888e75269dc2f18eftree
parentb3bedbdf7d43baa45ddbe15ea6afc2b9fad476a5commit | 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