Backportin r181323 and r18133 from trunk: Massive search core-query speed improvement.
authormiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Sat, 2 Oct 2010 13:49:55 +0000 (13:49 +0000)
committermiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Sat, 2 Oct 2010 13:49:55 +0000 (13:49 +0000)
commit21165a6f002820a7e4f647a7804640dbb02a8453
treebb020fb7264105c77c67d58c2484dcfdfc4e84a9
parent0a7edd17b0d70df1bb6da55f978c2b7d7f21399d
Backportin r181323 and r18133 from trunk: Massive search core-query speed improvement.

 * Only compile the tsquery once
 * Use direct ids instead of going back to the db udring a queyr
 * Change a remaining CASE to COALESCE/NULLIF

git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_2_0@18135 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/perlmods/OpenILS/Application/Storage/Driver/Pg/QueryParser.pm