From 3b75b8f3ae01f77b9f5fd0e9bd233ebf8bbe0965 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Fri, 10 Jun 2011 16:58:03 -0400 Subject: [PATCH] lp#795737: improve staff bib search copy visibility check An errant join in query used to see if a bib is visible in the search OU scope for a bib search initiated from the staff client signficantly degrade the speed of such searches. Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/300.schema.staged_search.sql | 1 - 1 file changed, 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/300.schema.staged_search.sql b/Open-ILS/src/sql/Pg/300.schema.staged_search.sql index 2ab2efd2dd..42326a030f 100644 --- a/Open-ILS/src/sql/Pg/300.schema.staged_search.sql +++ b/Open-ILS/src/sql/Pg/300.schema.staged_search.sql @@ -236,7 +236,6 @@ BEGIN PERFORM 1 FROM asset.call_number cn JOIN asset.copy cp ON (cp.call_number = cn.id) - JOIN actor.org_unit a ON (cp.circ_lib = a.id) WHERE NOT cn.deleted AND NOT cp.deleted AND cp.circ_lib IN ( SELECT * FROM search.explode_array( search_org_list ) ) -- 2.11.0