projects / evergreen / joelewis.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: f2a547a) | 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:51:00 +0000 (00:51 -0400)
commit6854ddfdc114d26239aa22ff453fa12a2a1a7a26
tree8a4feefd1cdb1a721f6a8bada0cf0a5c77c37502tree
parentf2a547a6c0bcf50e7df6dfa5bd5467c342115487commit | 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 working repo (Joseph Lewis)