]> git.evergreen-ils.org Git - working/Evergreen.git/commit
LP#1482757: Speed Up the Delete of Orphaned URIs in upgrade script
authorJason Stephenson <jason@sigio.com>
Thu, 24 Sep 2020 16:31:23 +0000 (12:31 -0400)
committerMichele Morgan <mmorgan@noblenet.org>
Fri, 25 Feb 2022 21:21:00 +0000 (16:21 -0500)
commit160690af7091d38db88eecdfb9df2cbf8092ca88
tree5bcd2677952e115d01a4df143ed023c86f9800fc
parent6d621d264fab6aa3e49ecad1a11eb1858400810f
LP#1482757: Speed Up the Delete of Orphaned URIs in upgrade script

Modify the code that deletes orphaned asset.uri table entries in the
upgrade script to use IN logic on the subquery, because IN is much
faster than NOT IN.  Also take into account the link between
serial.item and asset.uri so that we don't accidentally delete URIs
used by serial items.

Signed-off-by: Jason Stephenson <jason@sigio.com>
Signed-off-by: Jessica Woolford <jwoolford@biblio.org>
Signed-off-by: Michele Morgan <mmorgan@noblenet.org>
Open-ILS/src/sql/Pg/upgrade/XXXX.function.biblio.extract_located_uris.sql