LP#1846354 various speed improvements
authorMike Rylander <mrylander@gmail.com>
Tue, 8 Sep 2020 19:12:06 +0000 (15:12 -0400)
committerChris Sharp <csharp@georgialibraries.org>
Wed, 3 Mar 2021 17:56:48 +0000 (12:56 -0500)
commitc6226a032e0e38a3807fe7608f728a70efb209bb
tree931dd9c2e896ab8e86059f43536e810e89b67c1d
parent03e8349a79ad3ced69ee0215510c291311c177da
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>
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