Changes between Version 3 and Version 4 of DatabaseBasedAnalysis/Benchmarking

Timestamp:

08/04/18 16:16:45 (6 years ago)

Author:

tbretz

Comment:

--

DatabaseBasedAnalysis/Benchmarking

@@ -315 +315 @@
 }}}
 
+---
+
+{{{
+SELECT
+   Events.*
+FROM 
+   Events
+WHERE
+   FileId IN ($LIST) --
+}}}
+
+{{{
+------------------------ Rootify SQL -------------------------
+Reading query from file './crab-data-only.sql'.
+Found 317 list element(s) for ${LIST}
+Connecting to database...
+Client Version: 5.7.23
+Server Version: 5.7.23-0ubuntu0.18.04.1
+Compression of databse connection is OFF
+Connection to databases is ENCRYPTED (DHE-RSA-AES256-SHA)
+Requesting data...
+Opening file '/dev/null' [compression=1]...
+Writing data to tree 'Result'
+Trying to setup 44 branches...
+Configured 44 branches.
+Filling branches...
+2305972 rows fetched.
+0 rows filled into tree.
+0 B written to disk.
+File closed.
+Execution time: 40.2818s (17.5 us/row)
+--------------------------------------------------------------
+
+
+Status                        Duration    CPU User  CPU System
+--------------------------------------------------------------
+[...]
+Sending data                 39.723849   27.236133    0.226700
+[...]
+--------------------------------------------------------------
+
+Bytes_sent       4 k
+Bytes_received   833 M
+}}}
+
+---
+
+{{{
+SELECT
+   Events.*
+FROM
+   Events
+LEFT JOIN RunInfo  USING (FileId)
+WHERE
+   fSourceKey=5
+AND
+   fRunTypeKey=1
+AND
+   FileId BETWEEN 131101000 AND 131107000
+AND
+   fZenithDistanceMax<35
+AND
+   fR750Ref/fR750Cor>0.9
+}}}
+
+{{{
+------------------------ Rootify SQL -------------------------
+Reading query from file './crab-data-only.sql'.
+Found 317 list element(s) for ${LIST}
+Connecting to database...
+Client Version: 5.7.23
+Server Version: 5.7.23-0ubuntu0.18.04.1
+Compression of databse connection is OFF
+Connection to databases is ENCRYPTED (DHE-RSA-AES256-SHA)
+Requesting data...
+Opening file '/dev/null' [compression=1]...
+Writing data to tree 'Result'
+Trying to setup 44 branches...
+Configured 44 branches.
+Filling branches...
+2305972 rows fetched.
+0 rows filled into tree.
+0 B written to disk.
+File closed.
+Execution time: 40.5847s (17.6 us/row)
+--------------------------------------------------------------
+
+
+Status                        Duration    CPU User  CPU System
+--------------------------------------------------------------
+[...]
+Sending data                 40.108342   26.946160    0.219184
+[...]
+--------------------------------------------------------------
+
+Bytes_sent       4 k
+Bytes_received   833 M
+}}}