Comment 2 for bug 1836963

Tested and works for me. Signed-off pushed to user/gmcharlt/lp1836963_signoff.

I've attached a test script that can be used to check timings before and after applying the patch. To create enough OUs in a Concerto database to make the performance increase apparent, you can run something like this:

insert into actor.org_unit (parent_ou, ou_type, ill_address, holds_address, mailing_address, billing_address, shortname, name, opac_visible)
select distinct 6, 4, 9, 9, 9, 9, 'BR3SL-' || upper(first_given_name || family_name), first_given_name || ' ' || family_name || ' Sub-library', true
from actor.usr;