Changeset 30462

Timestamp:

Feb 2, 2011, 2:00:11 PM (15 years ago)

Author:

watersc1

Message:

Set a limit in the JOIN statement to speed up execution.

File:

• trunk/ippTools/share/regtool_pendingexp.sql (modified) (1 diff)

trunk/ippTools/share/regtool_pendingexp.sql

@@ -48 +48 @@
           GROUP BY newExp.exp_id
           HAVING SUM(rawImfile.fault) = 0
+          LIMIT 256
          ) AS RAWEXPOSURES
          USING (exp_id)