LP#1374091: Speed up metarecord version of unAPI mra call user/miker/record_attr_flat_flat
authorMike Rylander <mrylander@gmail.com>
Mon, 29 Sep 2014 16:40:32 +0000 (12:40 -0400)
committerMike Rylander <mrylander@gmail.com>
Mon, 29 Sep 2014 16:40:32 +0000 (12:40 -0400)
commit9d4462accf1f9fb981c898e34371dd977b6f718b
tree826f025904f9f095bda6c605e84367add187153b
parentb6391eb441cb368d555883c08e71c14f626dae25
LP#1374091: Speed up metarecord version of unAPI mra call

The change to metabib.record_attr_flat in the previous commit caused
a regression in the plan used in unapi.mmr_mra.  This commit addresses
that by unrolling the mra view when used in context with metarecords,
which are shaped differently and require slightly different access
patterns.

Signed-off-by: Mike Rylander <mrylander@gmail.com>
Open-ILS/src/sql/Pg/990.schema.unapi.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.record_attr_flat_speedup.sql