Changeset 19582 for trunk/ippTools/share/difftool_inputskyfile.sql

Timestamp:

Sep 16, 2008, 10:09:43 AM (18 years ago)

Author:

Paul Price

Message:

Optimising difftool -inputskyfile: this was driving the load on the mysql server way high. The problem is that there were two sub-selects that are UNION-ed, and then the search criteria were applied. The new version applies the search criteria to each sub-select separately, resulting in about a 20-fold reduction in execution time. Main patch by Josh, with a small fix by me.

File:

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

trunk/ippTools/share/difftool_inputskyfile.sql

@@ -35 +35 @@
         AND camRun.state = 'full'
         AND chipRun.state = 'full'
+        -- where hook %s
     UNION
     SELECT 
@@ -71 +72 @@
         AND camRun.state = 'full'
         AND chipRun.state = 'full'
+        -- where hook %s
     ) as Foo