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

File export-times-auster-ref.txt, 3.4 KB (added by Nicklas Nordborg, 13 years ago)

Reference measurements of BioAssaySetExporter? on auster

Line 
1Tests was done on my development machine (auster). Results
2should not be compared to results made on other computers.
3
4The test was made on a fresh installation of BASE 2.11 on
5MySQL 5.0.67 which was initialised with 100 raw data sets
6following the instructions in
7http://base.thep.lu.se/wiki/Specifications/Test_procedures/Performance
8
9The following tests were made from the web interface. The
10main purpose of the tests are to find points in the
11BioAssaySetExporter that we think can be improved. The results
12are also needed to make sure that we don't make things worse.
13
14The tests was made on a root bioassay set and on a filtered
15bioassay set. The filtered bioassay set is interesting because
16it needs to join an extra table in the SQL.
17
18# = Number of assays
191 = First run
202 = Second run
21S = Serial format
22M = Matrix format
23MeV = MeV format
24
25
26Export 1
27========
28Format: Serial and Matrix
29Fields: ch1, ch2
30
31Root bioassay set:
32# S1  S2  M1  M2
33------------------------------------
3410  0.06  0.07  0.07  0.06
3520  0.11  0.12  0.11  0.11
3640  0.22  0.22  0.20  0.21
3780  0.52  0.42  0.42  0.41
38
39Filtered bioassay set:
40# S1  S2  M1  M2
41------------------------------------
4210  0.39  0.40  0.14  0.13
4320  1.08  1.03  0.23  0.25
4440  2.19  0.33  0.38  0.29
4580  1.11  0.58  1.09  0.47
46
47
48
49Export 2
50========
51Format: Serial and Matrix
52Fields: ch1, ch2
53Reporter: External Id
54
55Root bioassay set:
56# S1  S2  M1  M2
57------------------------------------
5810  0.11  0.11  0.19  0.18
5920  0.21  0.25  0.35  0.35
6040  0.38  0.39  1.08  1.08
6180  1.18  1.13  2.18  2.14
62
63Filtered bioassay set:
64# S1  S2  M1  M2
65------------------------------------
6610  0.27  0.14  0.32  0.14
6720  0.25  0.25  0.35  0.40
6840  0.47  0.46  1.22  1.10
6980  1.32  0.31  2.23  12.57
70
71
72Export 3
73========
74Format: Serial, Matrix and MeV
75Fields: ch1, ch2
76Reporter: all
77
78Root bioassay set:
79# S1  S2  M1  M2  MeV1  Mev2
80----------------------------------------------------
8110  2.27  2.31  2.27  2.27  2.52  2.53
8220  4.57  4.50  4.55  4.53  5.42  5.45
8340  9.44  9.50  9.45  9.54  11.28 11.56
8480  11.43 20.41 19.53 20.20 23.27 23.03
85
86Filtered bioassay set:
87# S1  S2  M1  M2  MeV1  Mev2
88----------------------------------------------------
8910  2.38  2.59  2.11  2.12  2.32  2.35
9020  7.39  11.14 4.35  4.39  5.20  5.18
9140  24.11 24.43 9.27  9.40  10.58 10.47
9280  39.16 41.19 85.36 20.20 21.55 102.09
93
94
95Export 4
96========
97Format: Serial and Matrix
98Fields: ch1, ch2, FG Mean (both channels)
99
100Root bioassay set:
101# S1  S2  M1  M2
102------------------------------------
10310  0.15  0.15  0.11  0.11
10420  0.25  0.27  0.20  0.20
10540  0.48  1.05  0.40  0.41
10680  3.20  2.36  3.01  3.06
107
108Filtered bioassay set:
109# S1  S2  M1  M2
110------------------------------------
11110  0.42  1.23  0.12  0.11
11220  1.40  1.07  0.26  0.24
11340  1.37  1.43  0.56  0.45
11480  2.57  2.57  4.43  2.11
115
116
117Export 5
118========
119Format: Serial and Matrix
120Fields: all
121
122Root bioassay set:
123# S1  S2  M1  M2
124------------------------------------
12510  0.46  0.45  0.47  0.46
12620  1.31  1.30  1.32  1.31
12740  2.56  2.59  3.01  3.12
12880  6.23  6.12  7.25  7.21
129
130Filtered bioassay set:
131# S1  S2  M1  M2
132------------------------------------
13310  0.45  0.45  0.47  0.46
13420  1.31  1.31  1.36  1.34
13540  2.58  2.58  3.06  3.03
13680  6.35  6.39  9.33  8.08
137
138
139Export 6
140========
141Format: Serial and Matrix
142Fields: all
143Reporter: all
144
145Root bioassay set:
146# S1  S2  M1  M2
147-------------------------------------
14810  3.00  3.01  2.41  2.44
14920  5.54  5.59  5.23  5.18
15040  11.50 14.02 10.47 13.49
15180  24.37 24.30 25.47 25.45
152
153Filtered bioassay set:
154# S1  S2  M1  M2
155-------------------------------------
15610  3.17  4.03  2.29  2.29
15720  12.36 12.02 5.14  5.26
15840  24.52 26.55 10.32 10.54
15980  53.25 52.05 28.38 88.38
160