projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: ce9f58a) | patch
LP#1304559 Fix slow Vandelay-based imports user/dbwells/lp1304559_record_import_timeout
authorDan Wells <dbw2@calvin.edu>
Thu, 10 Apr 2014 13:15:07 +0000 (09:15 -0400)
committerDan Wells <dbw2@calvin.edu>
Thu, 10 Apr 2014 13:15:07 +0000 (09:15 -0400)
commitcd9b544c21b55fbe4aeb201b64b65b9d355ad78f
tree2a0975d9f700cc5dd0eab57a3f7846cf8a421f8etree
parentce9f58a3a8293ebf9070587f7c4b5806e196ceb6commit | 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>
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 ILS