projects / evergreen / pines.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 5104438) | patch
Use LIMIT to speed EXISTS subqueries
authorMike Rylander <mrylander@gmail.com>
Tue, 12 Feb 2013 16:51:16 +0000 (11:51 -0500)
committerBen Shum <bshum@biblio.org>
Wed, 27 Feb 2013 18:03:39 +0000 (13:03 -0500)
commita605e9beb482bcdc8eee54c91b73125ebbde2f01
tree24cb858e9bb6023d776ffaa5dd324fb9145e2ad7tree
parent51044386d3caafeafc4610c7bcd635e0d3d1c9ddcommit | diff
Use LIMIT to speed EXISTS subqueries

EXISTS without LIMIT is considered harmful in many cases.  Thus, we will
apply such an explicit planner hint in SuperCat.  This reduces the runtime
of URI lookups on some records from 1.2s+ to less than 1ms.

Signed-off-by: Mike Rylander <mrylander@gmail.com>
Signed-off-by: Ben Shum <bshum@biblio.org>
Open-ILS/src/perlmods/lib/OpenILS/Application/SuperCat.pm diff | blob | history
Evergreen working repo (PINES)