]> git.evergreen-ils.org Git - Evergreen.git/commit
projects / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 84bfb1c) | patch
LP#928896 improve row estimate for action.usr_visible_circ_copies()
authorGalen Charlton <gmc@esilibrary.com>
Wed, 8 Feb 2012 15:01:24 +0000 (10:01 -0500)
committerBill Erickson <berick@esilibrary.com>
Wed, 8 Feb 2012 15:25:54 +0000 (10:25 -0500)
commit5e36baf3a8fc4754693e6813df6be1ef0108aa16
treea554a8d85fd52c5cce060bc290503142872cde7btree
parent84bfb1cc1d41d4fd6f3798204049bfdd192394aecommit | diff
LP#928896 improve row estimate for action.usr_visible_circ_copies()

Fixes problem where use of this function by the tagging circs in search
results feature can result in sequential scans of asset.call_number.

Thanks to Mike Rylander for the suggestion.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Signed-off-by: Bill Erickson <berick@esilibrary.com>
Open-ILS/src/sql/Pg/090.schema.action.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.usr_visible_circ_copies_row_estimates.sql [new file with mode: 0644] blob
Evergreen ILS