LP#1501471: add DB function for batch retrieval of OU settings user/gmcharlt/lp1501471_batch_retrieve_ous_faster
authorGalen Charlton <gmc@esilibrary.com>
Wed, 30 Sep 2015 22:11:55 +0000 (22:11 +0000)
committerGalen Charlton <gmc@esilibrary.com>
Wed, 30 Sep 2015 22:11:55 +0000 (22:11 +0000)
commit665bdcfe1bf498f7854004b2b3d4a8edce29820e
tree441f99c2f2ce2f5a64f5a4d5d99248b9cb5addd4
parenta7a31aa2412f9c07c8724a7c27dd43da3bdc9b0b
LP#1501471: add DB function for batch retrieval of OU settings

This adds a new stored function and a utility routine that uses it
for retrieving a set of OU settings in one fell swoop.  This offers
a significant speed boost for the Dojo patron editor, which loads
about 70 OU settings when it initalizes itself.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Open-ILS/src/perlmods/lib/OpenILS/Application/Actor.pm
Open-ILS/src/perlmods/lib/OpenILS/Application/AppUtils.pm
Open-ILS/src/sql/Pg/020.schema.functions.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.batch_settings_retrieve_function.sql [new file with mode: 0644]