From 86cf8555661a1c8b4b9c5a15f013c8c4fbbb8e05 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 Signed-off-by: Bill Erickson --- 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