projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: b842239) | patch
LP#1479953: Add indexes to vqbr foreign key references user/jeffdavis/lp1479953-delete-bib-queue-speedup
authorJeff Davis <jdavis@sitka.bclibraries.ca>
Thu, 30 Jul 2015 20:12:35 +0000 (13:12 -0700)
committerJeff Davis <jdavis@sitka.bclibraries.ca>
Thu, 30 Jul 2015 20:12:35 +0000 (13:12 -0700)
commit5e75ce4bee20fc3c3348b1e607ba65738b159abe
tree0db17363776d929464d990aa0d4ff16e06c35fcatree
parentb8422397ff57cb4f2709db75451db8a97eb19575commit | diff
LP#1479953: Add indexes to vqbr foreign key references

Deleting a bib queue can be quite slow if it contains many queued
records.  This is because each queued record needs to be deleted, and
this in turn affects many tables that contain unindexed foreign key
references to vandelay.queued_bib_record.  Indexing those foreign keys
can speed up bib queue deletion substantially.

Signed-off-by: Jeff Davis <jdavis@sitka.bclibraries.ca>
Open-ILS/src/sql/Pg/012.schema.vandelay.sql diff | blob | history
Open-ILS/src/sql/Pg/200.schema.acq.sql diff | blob | history
Open-ILS/src/sql/Pg/201.acq.audit-functions.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.index.queued_record.sql [new file with mode: 0644] blob
Evergreen ILS