]> git.evergreen-ils.org Git - Evergreen.git/commit
improve performance of multi-class searches
authorgmc <gmc@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Mon, 24 Jan 2011 18:43:03 +0000 (18:43 +0000)
committergmc <gmc@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Mon, 24 Jan 2011 18:43:03 +0000 (18:43 +0000)
commit940a7011d8ccff4b729eb940e4c898f4ec6afca1
treed7e579924efb52d95b9276a4e97ffbf047c6b4ad
parent825cc31d83c5839dd6f3634ca7dc0cd08a129f1a
improve performance of multi-class searches

Backport of trunk commit 18233.

For as yet unknown reasons, Postgres sometimes uses
nested loops instead of hash joins when joining subqueries
in a multi-class bib search.  This can result in searches
such as "author:rowling title:harry potter" never completing.

Removing the interior limit clause can both speed up the query
and make search results more accurate when combining queries
of two or more common words.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_6_2@19264 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/sql/Pg/300.schema.staged_search.sql