Changeset 38607

Timestamp:

Jul 20, 2015, 11:58:03 AM (11 years ago)

Author:

heather

Message:

fix minidvodbrunaddrun query to be faster, as suggested by gene

File:

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

trunk/ippTools/share/addtool_checkminidvodbaddrun.sql

@@ -12 +12 @@
         FROM addRun where minidvodb_group = '%s'
         GROUP BY minidvodb_name ) 
-   AS foo1 ON minidvodb_name = minidbn
+   AS foo1 ON minidvodb_name = minidbn 
         -- the second select grabs and counts all the addRuns with state
         -- of 'full'         
-   WHERE addRun.state = 'full' 
+   WHERE addRun.state = 'full' and minidvodb_group = minidbg
    GROUP BY minidvodb_name ) 
 AS foo2