LP#1846354 various speed improvements
authorMike Rylander <mrylander@gmail.com>
Tue, 8 Sep 2020 19:12:06 +0000 (15:12 -0400)
committerJason Etheridge <jason@EquinoxOLI.org>
Mon, 20 Sep 2021 13:29:45 +0000 (09:29 -0400)
commit80c8944e4612851dce367f61f6ccc13df6b097a4
treec8991a65b832d565b90cd682cda3e04c8c293ba0
parent04e14ee75e161d71c4cb33a3e313087c151731b4
LP#1846354 various speed improvements

* Adjust upgrade script for speed

This commit makes minor adjustments to the upgrade script to speed it up
in the face of larger data sets.

NOTE: The DO blocks that provided assertion tests during the the upgrade
have been commented out, as they primarily test that the preceding
insert did not break in some way that would have inserted data from the
wrong table into the intermediate staging tables.  They take a very long
time to run in some cases, but are left here for testers to enable in
order to confirm that they would pass in production.

* Move the deleted filter out of the query for speed

* Rework aum and ausp to use the same sequence, and aump view to use UNION ALL

Signed-off-by: Mike Rylander <mrylander@gmail.com>
Signed-off-by: Jason Etheridge <jason@EquinoxInitiative.org>
Signed-off-by: Terran McCanna <tmccanna@georgialibraries.org>
Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>
Open-ILS/examples/fm_IDL.xml
Open-ILS/src/perlmods/lib/OpenILS/Application/Actor.pm
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.note_and_message_consolidation
docs/RELEASE_NOTES_NEXT/Client/lp1846354_consolidate_patron_notes.adoc