LP#1374091: Speed up metarecord version of unAPI mra call
authorMike Rylander <mrylander@gmail.com>
Mon, 29 Sep 2014 16:40:32 +0000 (12:40 -0400)
committerBen Shum <bshum@biblio.org>
Thu, 9 Oct 2014 15:57:03 +0000 (11:57 -0400)
commit04d618aa860afbcd90d8dcfb57c7f26cb433bb2e
treeb9be1b0bceeb60a17f2b69693523ee83dcbc241b
parent82749860db5cf3b53b4cd5be3395b06ea284efae
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>
Signed-off-by: Ben Shum <bshum@biblio.org>
Open-ILS/src/sql/Pg/990.schema.unapi.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.record_attr_flat_speedup.sql