projects / evergreen / pines.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 12319bb) | patch
LP#1304559 Fix slow Vandelay-based imports
authorDan Wells <dbw2@calvin.edu>
Thu, 10 Apr 2014 13:15:07 +0000 (09:15 -0400)
committerBen Shum <bshum@biblio.org>
Thu, 10 Apr 2014 21:46:13 +0000 (17:46 -0400)
commitd42fbecebddbb33bbb83fad4e7994d8b08237b76
treeda1ea5f82ca9e9a90a35d85d96d367e2edabe433tree
parent12319bb483d9a0d1e53db552b1f44f6866dcfea1commit | diff
LP#1304559 Fix slow Vandelay-based imports

Whether a planning limitation or otherwise, we have seen a few cases
where queries run very, very slowly (appear to hang) when using the
updated metabib.record_attr view in a WHERE clause.

The simplest code change is to switch Vandelay to use the intermediate
'_flat' view instead, and early reports indicate that this at least
gets us back to a functional state.

Signed-off-by: Dan Wells <dbw2@calvin.edu>
Signed-off-by: Ben Shum <bshum@biblio.org>
Open-ILS/src/sql/Pg/012.schema.vandelay.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.function.vandelay_record_attr_to_flat.sql [new file with mode: 0644] blob
Evergreen working repo (PINES)