Changes between Version 4 and Version 5 of DatabaseBasedAnalysis/Benchmarking

Timestamp:

08/04/18 16:27:13 (7 years ago)

Author:

tbretz

Comment:

--

DatabaseBasedAnalysis/Benchmarking

@@ -413 +413 @@
 Bytes_received   833 M
 }}}
+
+---
+
+{{{
+SELECT
+   Events.*,
+   Position.X,
+   Position.Y
+FROM
+   Events
+LEFT JOIN RunInfo  USING (FileId)
+LEFT JOIN Position USING (FileId, EvtNumber)
+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 46 branches...
+Configured 46 branches.
+Filling branches...
+2305972 rows fetched.
+0 rows filled into tree.
+0 B written to disk.
+File closed.
+Execution time: 41.8071s (18.1 us/row)
+--------------------------------------------------------------
+
+
+Status                        Duration    CPU User  CPU System
+--------------------------------------------------------------
+[...]
+Sending data                 41.283198   30.585062    0.342441
+[...]
+--------------------------------------------------------------
+
+Bytes_sent       4 k
+Bytes_received   872 M
+}}}