]> git.evergreen-ils.org Git - contrib/Conifer.git/commit
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 16:00:44 +0000 (12:00 -0400)
commitf24f275ff258ce140e389c46245ff285c208520b
treeccfc682621a18d25db30739d7d63a8fa22caf4cb
parent6d5a70a4a2f625ee51bc55db35ebeca5d8039147
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