Changes between Version 71 and Version 72 of DatabaseBasedAnalysis

Timestamp:

08/06/18 16:08:12 (6 years ago)

Author:

tbretz

Comment:

--

DatabaseBasedAnalysis

@@ -636 +636 @@
                     /* Table6 */
                     SELECT
-                        Weight, Leakage1, Dist, WL, LX,
-                        M3Long*Sign*0.0117193246260285378    AS M3L,
+                        Weight, Leakage1, WL, LX,
+                        Norm          *0.0117193246260285378 AS Dist,
+                        M3Long   *Sign*0.0117193246260285378 AS M3L,
                         SlopeLong*Sign/0.0117193246260285378 AS Slope
                     FROM
@@ -643 +644 @@
                         /* Table5 */
                         SELECT
-                            Weight, M3Long, SlopeLong, Leakage1, Dist, WL, LX,
+                            Weight, M3Long, SlopeLong, Leakage1, Norm, WL, LX,
                             ASIN(LX) AS Alpha,
                             SIGN(LY) AS Sign
@@ -650 +651 @@
                             /* Table4 */
                             SELECT
-                                Weight, M3Long, SlopeLong, Leakage1, Dist, WL,
+                                Weight, M3Long, SlopeLong, Leakage1, Norm, WL,
                                 TRUNCATE((CosDelta*DY - SinDelta*DX)/Norm, 6) AS LX,
                                 TRUNCATE((CosDelta*DX + SinDelta*DY)/Norm, 6) AS LY
@@ -658 +659 @@
                                 SELECT
                                     Weight, CosDelta, SinDelta, DX, DY, M3Long, SlopeLong, Leakage1, WL,
-                                    SQRT(DX*DX + DY*DY)                       AS Norm,
-                                    SQRT(DX*DX + DY*DY)*0.0117193246260285378 AS Dist
+                                    SQRT(DX*DX + DY*DY) AS Norm
                                 FROM
                                 (
@@ -753 +753 @@
 This new query results in 
 {{{
-Execution time: 14.9965s
+Execution time: 14.815s
 }}}