Ticket #1238: export-times-auster-ref.txt

Tests was done on my development machine (auster). Results 
should not be compared to results made on other computers.

The test was made on a fresh installation of BASE 2.11 on 
MySQL 5.0.67 which was initialised with 100 raw data sets 
following the instructions in
http://base.thep.lu.se/wiki/Specifications/Test_procedures/Performance

The following tests were made from the web interface. The 
main purpose of the tests are to find points in the 
BioAssaySetExporter that we think can be improved. The results
are also needed to make sure that we don't make things worse.

The tests was made on a root bioassay set and on a filtered
bioassay set. The filtered bioassay set is interesting because
it needs to join an extra table in the SQL.

# = Number of assays
1 = First run
2 = Second run
S = Serial format
M = Matrix format
MeV = MeV format


Export 1
========
Format: Serial and Matrix
Fields: ch1, ch2

Root bioassay set:
# S1  S2  M1  M2
------------------------------------
10  0.06  0.07  0.07  0.06
20  0.11  0.12  0.11  0.11
40  0.22  0.22  0.20  0.21
80  0.52  0.42  0.42  0.41

Filtered bioassay set:
# S1  S2  M1  M2
------------------------------------
10  0.39  0.40  0.14  0.13
20  1.08  1.03  0.23  0.25
40  2.19  0.33  0.38  0.29
80  1.11  0.58  1.09  0.47



Export 2
========
Format: Serial and Matrix
Fields: ch1, ch2
Reporter: External Id

Root bioassay set:
# S1  S2  M1  M2
------------------------------------
10  0.11  0.11  0.19  0.18
20  0.21  0.25  0.35  0.35
40  0.38  0.39  1.08  1.08
80  1.18  1.13  2.18  2.14

Filtered bioassay set:
# S1  S2  M1  M2
------------------------------------
10  0.27  0.14  0.32  0.14
20  0.25  0.25  0.35  0.40
40  0.47  0.46  1.22  1.10
80  1.32  0.31  2.23  12.57


Export 3
========
Format: Serial, Matrix and MeV
Fields: ch1, ch2
Reporter: all

Root bioassay set:
# S1  S2  M1  M2  MeV1  Mev2
----------------------------------------------------
10  2.27  2.31  2.27  2.27  2.52  2.53
20  4.57  4.50  4.55  4.53  5.42  5.45
40  9.44  9.50  9.45  9.54  11.28 11.56
80  11.43 20.41 19.53 20.20 23.27 23.03

Filtered bioassay set:
# S1  S2  M1  M2  MeV1  Mev2
----------------------------------------------------
10  2.38  2.59  2.11  2.12  2.32  2.35
20  7.39  11.14 4.35  4.39  5.20  5.18
40  24.11 24.43 9.27  9.40  10.58 10.47
80  39.16 41.19 85.36 20.20 21.55 102.09


Export 4
========
Format: Serial and Matrix
Fields: ch1, ch2, FG Mean (both channels)

Root bioassay set:
# S1  S2  M1  M2
------------------------------------
10  0.15  0.15  0.11  0.11
20  0.25  0.27  0.20  0.20
40  0.48  1.05  0.40  0.41
80  3.20  2.36  3.01  3.06

Filtered bioassay set:
# S1  S2  M1  M2
------------------------------------
10  0.42  1.23  0.12  0.11
20  1.40  1.07  0.26  0.24
40  1.37  1.43  0.56  0.45
80  2.57  2.57  4.43  2.11


Export 5
========
Format: Serial and Matrix
Fields: all

Root bioassay set:
# S1  S2  M1  M2
------------------------------------
10  0.46  0.45  0.47  0.46
20  1.31  1.30  1.32  1.31
40  2.56  2.59  3.01  3.12
80  6.23  6.12  7.25  7.21

Filtered bioassay set:
# S1  S2  M1  M2
------------------------------------
10  0.45  0.45  0.47  0.46
20  1.31  1.31  1.36  1.34
40  2.58  2.58  3.06  3.03
80  6.35  6.39  9.33  8.08


Export 6
========
Format: Serial and Matrix
Fields: all
Reporter: all

Root bioassay set:
# S1  S2  M1  M2
-------------------------------------
10  3.00  3.01  2.41  2.44
20  5.54  5.59  5.23  5.18
40  11.50 14.02 10.47 13.49
80  24.37 24.30 25.47 25.45

Filtered bioassay set:
# S1  S2  M1  M2
-------------------------------------
10  3.17  4.03  2.29  2.29
20  12.36 12.02 5.14  5.26
40  24.52 26.55 10.32 10.54
80  53.25 52.05 28.38 88.38