Changeset 30463

Timestamp:

Feb 2, 2011, 2:01:32 PM (15 years ago)

Author:

watersc1

Message:

set a limit in the JOIN to prevent large backlogs from killing the database server

File:

• tags/ipp-20101215/ippTools/share/regtool_pendingexp.sql (modified) (1 diff)

tags/ipp-20101215/ippTools/share/regtool_pendingexp.sql

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