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/kmlussier/lp1479953-delete-bib-queue-speedup
authorJeff Davis <jdavis@sitka.bclibraries.ca>
Thu, 30 Jul 2015 20:12:35 +0000 (13:12 -0700)
committerKathy Lussier <klussier@masslnc.org>
Wed, 5 Aug 2015 19:23:45 +0000 (15:23 -0400)
commit6112711f6f4f99bff3ef696b43b22888f6514fe9
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>
Signed-off-by: Kathy Lussier <klussier@masslnc.org>
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