Changeset 17618 for trunk/ippTools/share/regtool_pendingexp.sql

Timestamp:

May 9, 2008, 11:48:09 AM (18 years ago)

Author:

jhoblitt

Message:

further attempts to optimize the use of the regtool_pendingexp.sql query

File:

• trunk/ippTools/share/regtool_pendingexp.sql (modified) (2 diffs)

trunk/ippTools/share/regtool_pendingexp.sql

@@ -29 +29 @@
         newExp.state = 'run'
         AND rawExp.exp_id IS NULL
+-- where hook %s
     GROUP BY
         newExp.exp_id
@@ -34 +35 @@
         COUNT(newImfile.tmp_class_id) = COUNT(rawImfile.tmp_class_id)
         AND SUM(rawImfile.fault) = 0
---   ) as Foo
+-- limit hook %s
+    ) as Foo