Changeset 31076

Timestamp:

Mar 28, 2011, 11:53:11 PM (15 years ago)

Author:

watersc1

Message:

Changed how the JOINs function between chipRun and rawExp. Forcing it through chipProcessedImfile seems a bit insane to me, and so switching it to just carrying the exp_id in the USING statement seems to result in a substantial increase in speed. The results appear to be what would be expected.

No clue why this is suddenly an issue.

File:

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

trunk/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