Changeset 31077

Timestamp:

Mar 29, 2011, 12:05:48 AM (15 years ago)

Author:

watersc1

Message:

fix the joins to speed up the fake stage.

File:

• tags/ipp-20110218/ippTools/share/faketool_pendingimfile.sql (modified) (1 diff)

tags/ipp-20110218/ippTools/share/faketool_pendingimfile.sql

@@ -28 +28 @@
 JOIN camProcessedExp USING(cam_id)
 JOIN chipRun USING(chip_id)
-JOIN chipProcessedImfile USING(chip_id)
-JOIN rawExp
-    ON chipProcessedImfile.exp_id = rawExp.exp_id
+JOIN chipProcessedImfile USING(chip_id,exp_id)
+JOIN rawExp USING(exp_id)
+--    ON chipProcessedImfile.exp_id = rawExp.exp_id
 LEFT JOIN fakeProcessedImfile
     ON fakeRun.fake_id = fakeProcessedImfile.fake_id