]> git.evergreen-ils.org Git - Evergreen.git/commit
LP#800706: add index to serial.record_entry.record
authorGalen Charlton <gmc@esilibrary.com>
Tue, 12 May 2015 19:27:07 +0000 (15:27 -0400)
committerJason Stephenson <jstephenson@mvlc.org>
Wed, 13 May 2015 18:02:48 +0000 (14:02 -0400)
commit619a1707585da5c0add76085e696a00d63103886
tree487735706e4a1f2e093c4e190f799e8f7731922e
parente77a803e77adee8ef1ac03899159addf6328bcdf
LP#800706: add index to serial.record_entry.record

This patch adds index on the record column of serial.record_entry,
which can improve performance when displaying record details pages
in databases that have a large number MFHDs.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Signed-off-by: Jason Stephenson <jstephenson@mvlc.org>
Open-ILS/src/sql/Pg/210.schema.serials.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.index-record-in-sre.sql [new file with mode: 0644]