lp#795737: improve staff bib search copy visibility check bugs/rel_2_0/lp795737
authorGalen Charlton <gmc@esilibrary.com>
Fri, 10 Jun 2011 20:58:03 +0000 (16:58 -0400)
committerGalen Charlton <gmc@esilibrary.com>
Fri, 10 Jun 2011 20:58:03 +0000 (16:58 -0400)
commit3b75b8f3ae01f77b9f5fd0e9bd233ebf8bbe0965
tree511b09a4f8de153ff6ef115f8b870f0b30a2b9ab
parenta6f9b1f51c10d03d4063a808260ee8c996d8bf96
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 <gmc@esilibrary.com>
Open-ILS/src/sql/Pg/300.schema.staged_search.sql