Changeset 39528 for trunk/ippTools/share/addtool_checkminidvodbaddrun.sql

Timestamp:

Apr 13, 2016, 11:38:40 AM (10 years ago)

Author:

heather

Message:

addtool is slow, the queries needed some optimization, this is much faster

File:

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

trunk/ippTools/share/addtool_checkminidvodbaddrun.sql

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