Changeset 37381 for trunk/ippTools/share/laptool_exposures.sql

Timestamp:

Sep 9, 2014, 2:00:20 PM (12 years ago)

Author:

watersc1

Message:

Change to fake diff level information in the lap JOINs. I've left the
original code in as comments, in case we want to switch back in the
future.

This change makes the execution time of laptool -exposures drop from ~50s to ~0.25s.

File:

• trunk/ippTools/share/laptool_exposures.sql (modified) (4 diffs)

trunk/ippTools/share/laptool_exposures.sql

@@ -1 @@
-select DISTINCT V3.*,
-       diffRun.diff_id,diffRun.state as diffRun_state,
-       coalesce(CONVERT(sum(diffSkyfile.quality != 0),SIGNED),0) AS diff_bad_quality,
-       coalesce(CONVERT(count(diffSkyfile.diff_id),SIGNED),0) AS diff_component_count
-       FROM
+-- Join the diff information
+-- select DISTINCT V3.*,
+--       diffRun.diff_id,diffRun.state as diffRun_state,
+--       coalesce(CONVERT(sum(diffSkyfile.quality != 0),SIGNED),0) AS diff_bad_quality,
+--       coalesce(CONVERT(count(diffSkyfile.diff_id),SIGNED),0) AS diff_component_count
+--       FROM
+select V3.*,-1 as diff_id ,"full" as diffRun_state,0 as diff_bad_quality,0 AS diff_component_count FROM
+-- Join the warp information
 ( select V2.*,
        warpRun.warp_id,warpRun.state as warpRun_state,
@@ -10 +13 @@
        warpRun.magicked
        FROM
+-- Join the camera and fake information 
 ( select V1.*,
        camRun.cam_id,camRun.state as camRun_state,
@@ -15 +19 @@
        coalesce(CONVERT(count(camProcessedExp.cam_id),SIGNED),0) AS cam_component_count,
        fakeRun.fake_id,fakeRun.state as fakeRun_state FROM
+-- Get all the lap, exposure, chip stage information
 ( SELECT DISTINCT
        lap_id,lapRun.tess_id,projection_cell,filter,lapRun.state as lapRun_state, lapRun.registered, lapRun.fault, lapRun.label, lapRun.dist_group,
@@ -26 +31 @@
        GROUP BY lap_id,exp_id
        ) AS V1
+-- End lap/exposure/chip
        LEFT JOIN camRun USING(chip_id) LEFT JOIN camProcessedExp USING(cam_id)
        LEFT JOIN fakeRun USING(cam_id)
        GROUP BY lap_id,exp_id
   ) AS V2
+-- End camera/fake
   LEFT JOIN warpRun USING(fake_id) LEFT JOIN warpSkyfile USING(warp_id)
   GROUP BY lap_id,exp_id
 ) AS V3
-LEFT JOIN
-  (SELECT DISTINCT diff_id,warp1,warp2 FROM diffInputSkyfile) AS DI ON
-  (DI.warp1 = warp_id OR DI.warp2 = warp_id)
-LEFT JOIN diffRun USING(diff_id)
-LEFT JOIN diffSkyfile USING(diff_id)
+-- End warp
+-- LEFT JOIN
+--  (SELECT DISTINCT diff_id,warp1,warp2 FROM diffInputSkyfile) AS DI ON
+--  (DI.warp1 = warp_id OR DI.warp2 = warp_id)
+-- LEFT JOIN diffRun USING(diff_id)
+-- LEFT JOIN diffSkyfile USING(diff_id)
 GROUP BY lap_id,exp_id