More correct (but slow?) holdings/visibility tests; caching; letter paging links
authorLebbeous Fogle-Weekley <lebbeous@esilibrary.com>
Mon, 29 Apr 2013 19:51:18 +0000 (15:51 -0400)
committerLebbeous Fogle-Weekley <lebbeous@esilibrary.com>
Fri, 3 May 2013 13:57:49 +0000 (09:57 -0400)
commit03152ad836aa15d468d8ecda457d185e03bbfa55
tree4a3e5651de1fe1116cd2b50faae2ec107a1b550e
parentfb529800c65398d9192246bcec31763800767e77
More correct (but slow?) holdings/visibility tests; caching; letter paging links

The big VIEWs created in this commit probably need improvement or might
even need to be removed (and the bits in
metabib._browse_joins_and_where() that use them need would need to be
reverted) if they can't be made fast.

See VIEWs, generated query, and EXPLAIN ANALYZE output here:
http://nox.esilibrary.com/~lebbeous/explain-analyze-vis-view.txt

Signed-off-by: Lebbeous Fogle-Weekley <lebbeous@esilibrary.com>
Open-ILS/src/perlmods/lib/OpenILS/WWW/EGCatLoader/Browse.pm
Open-ILS/src/sql/Pg/upgrade/YYYY.schema.bib-auth-browse.sql
Open-ILS/src/templates/opac/browse.tt2
Open-ILS/src/templates/opac/parts/config.tt2
grand-visibility.sql [deleted file]