Changes between Version 2 and Version 3 of DatabaseBasedAnalysis/Benchmarking

Timestamp:

08/04/18 16:01:38 (6 years ago)

Author:

tbretz

Comment:

--

DatabaseBasedAnalysis/Benchmarking

@@ -153 +153 @@
 Status                        Duration    CPU User  CPU System
 --------------------------------------------------------------
-starting                      0.000125    0.000119    0.000004
-checking permissions          0.000004    0.000003    0.000001
-checking permissions          0.000002    0.000002    0.000000
-checking permissions          0.000003    0.000002    0.000000
-Opening tables                0.000018    0.000018    0.000000
-init                          0.000226    0.000000    0.000226
-System lock                   0.000008    0.000000    0.000008
-optimizing                    0.000016    0.000000    0.000016
-statistics                    0.000067    0.000000    0.000067
-preparing                     0.000016    0.000000    0.000016
-executing                     0.000003    0.000000    0.000002
+[...]
 Sending data                 74.844972   74.051538    0.809659
-end                           0.000011    0.000010    0.000001
-query end                     0.000009    0.000009    0.000000
-closing tables                0.000007    0.000006    0.000000
-freeing items                 0.000048    0.000047    0.000002
-cleaning up                   0.000014    0.000013    0.000000
+[...]
 --------------------------------------------------------------
 
@@ -292 +278 @@
 }}}
 
+With writing a file
+
+{{{
+------------------------ Rootify SQL -------------------------
+Reading query from file './crab.sql'.
+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 'crab.root' [compression=1]...
+Writing data to tree 'Result'
+Trying to setup 64 branches...
+12 branches skipped due to name starting with @.
+Configured 52 branches.
+Filling branches...
+13835838 rows fetched.
+6 rows skipped due to NULL field.
+13835832 rows filled into tree.
+2.7 GB written to disk.
+File closed.
+Execution time: 540.888s (39.1 us/row)
+--------------------------------------------------------------
+
+
+Status                        Duration    CPU User  CPU System
+--------------------------------------------------------------
+[...]
+Sending data                540.059249  473.963838    5.318202
+[...]
+--------------------------------------------------------------
+
+Bytes_sent       1.7 k
+Bytes_received   9 G
+}}}
+