]> git.evergreen-ils.org Git - Evergreen.git/commit
projects / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 33356f5) | patch
lp#795737: improve staff bib search copy visibility check
authorGalen Charlton <gmc@esilibrary.com>
Fri, 10 Jun 2011 20:58:03 +0000 (16:58 -0400)
committerBill Erickson <berick@esilibrary.com>
Fri, 10 Jun 2011 21:14:27 +0000 (17:14 -0400)
commit86cf8555661a1c8b4b9c5a15f013c8c4fbbb8e05
tree3a3a4c69430951842a1b433fd63999a28082c1d5tree
parent33356f5e84cbe915a97e36dd06f4c858e749e893commit | diff
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>
Signed-off-by: Bill Erickson <berick@esilibrary.com>
Open-ILS/src/sql/Pg/300.schema.staged_search.sql diff | blob | history
Evergreen ILS