projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: a7da0c2) | patch
Use LIMIT to speed EXISTS subqueries user/miker/supercat_uri_lookup_speed
authorMike Rylander <mrylander@gmail.com>
Tue, 12 Feb 2013 16:51:16 +0000 (11:51 -0500)
committerMike Rylander <mrylander@gmail.com>
Tue, 12 Feb 2013 16:57:10 +0000 (11:57 -0500)
commit007d6166691e83602c6a204986d6a1ee7c8e9392
tree6fa4b416beec9f7e90c5e5868ff87eb6725b312atree
parenta7da0c23c6c7392dbc2c9fa25a816a66708d8e2dcommit | 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>
Open-ILS/src/perlmods/lib/OpenILS/Application/SuperCat.pm diff | blob | history
Evergreen ILS