| 1 | Tests was done on my development machine (auster). Results
|
|---|
| 2 | should not be compared to results made on other computers.
|
|---|
| 3 |
|
|---|
| 4 | The test was made on a fresh installation of BASE 2.11 on
|
|---|
| 5 | MySQL 5.0.67 which was initialised with 100 raw data sets
|
|---|
| 6 | following the instructions in
|
|---|
| 7 | http://base.thep.lu.se/wiki/Specifications/Test_procedures/Performance
|
|---|
| 8 |
|
|---|
| 9 | The following tests were made from the web interface. The
|
|---|
| 10 | main purpose of the tests are to find points in the
|
|---|
| 11 | BioAssaySetExporter that we think can be improved. The results
|
|---|
| 12 | are also needed to make sure that we don't make things worse.
|
|---|
| 13 |
|
|---|
| 14 | The tests was made on a root bioassay set and on a filtered
|
|---|
| 15 | bioassay set. The filtered bioassay set is interesting because
|
|---|
| 16 | it needs to join an extra table in the SQL.
|
|---|
| 17 |
|
|---|
| 18 | # = Number of assays
|
|---|
| 19 | 1 = First run
|
|---|
| 20 | 2 = Second run
|
|---|
| 21 | S = Serial format
|
|---|
| 22 | M = Matrix format
|
|---|
| 23 | MeV = MeV format
|
|---|
| 24 |
|
|---|
| 25 |
|
|---|
| 26 | Export 1
|
|---|
| 27 | ========
|
|---|
| 28 | Format: Serial and Matrix
|
|---|
| 29 | Fields: ch1, ch2
|
|---|
| 30 |
|
|---|
| 31 | Root bioassay set:
|
|---|
| 32 | # S1 S2 M1 M2
|
|---|
| 33 | ------------------------------------
|
|---|
| 34 | 10 0.06 0.07 0.07 0.06
|
|---|
| 35 | 20 0.11 0.12 0.11 0.11
|
|---|
| 36 | 40 0.22 0.22 0.20 0.21
|
|---|
| 37 | 80 0.52 0.42 0.42 0.41
|
|---|
| 38 |
|
|---|
| 39 | Filtered bioassay set:
|
|---|
| 40 | # S1 S2 M1 M2
|
|---|
| 41 | ------------------------------------
|
|---|
| 42 | 10 0.39 0.40 0.14 0.13
|
|---|
| 43 | 20 1.08 1.03 0.23 0.25
|
|---|
| 44 | 40 2.19 0.33 0.38 0.29
|
|---|
| 45 | 80 1.11 0.58 1.09 0.47
|
|---|
| 46 |
|
|---|
| 47 |
|
|---|
| 48 |
|
|---|
| 49 | Export 2
|
|---|
| 50 | ========
|
|---|
| 51 | Format: Serial and Matrix
|
|---|
| 52 | Fields: ch1, ch2
|
|---|
| 53 | Reporter: External Id
|
|---|
| 54 |
|
|---|
| 55 | Root bioassay set:
|
|---|
| 56 | # S1 S2 M1 M2
|
|---|
| 57 | ------------------------------------
|
|---|
| 58 | 10 0.11 0.11 0.19 0.18
|
|---|
| 59 | 20 0.21 0.25 0.35 0.35
|
|---|
| 60 | 40 0.38 0.39 1.08 1.08
|
|---|
| 61 | 80 1.18 1.13 2.18 2.14
|
|---|
| 62 |
|
|---|
| 63 | Filtered bioassay set:
|
|---|
| 64 | # S1 S2 M1 M2
|
|---|
| 65 | ------------------------------------
|
|---|
| 66 | 10 0.27 0.14 0.32 0.14
|
|---|
| 67 | 20 0.25 0.25 0.35 0.40
|
|---|
| 68 | 40 0.47 0.46 1.22 1.10
|
|---|
| 69 | 80 1.32 0.31 2.23 12.57
|
|---|
| 70 |
|
|---|
| 71 |
|
|---|
| 72 | Export 3
|
|---|
| 73 | ========
|
|---|
| 74 | Format: Serial, Matrix and MeV
|
|---|
| 75 | Fields: ch1, ch2
|
|---|
| 76 | Reporter: all
|
|---|
| 77 |
|
|---|
| 78 | Root bioassay set:
|
|---|
| 79 | # S1 S2 M1 M2 MeV1 Mev2
|
|---|
| 80 | ----------------------------------------------------
|
|---|
| 81 | 10 2.27 2.31 2.27 2.27 2.52 2.53
|
|---|
| 82 | 20 4.57 4.50 4.55 4.53 5.42 5.45
|
|---|
| 83 | 40 9.44 9.50 9.45 9.54 11.28 11.56
|
|---|
| 84 | 80 11.43 20.41 19.53 20.20 23.27 23.03
|
|---|
| 85 |
|
|---|
| 86 | Filtered bioassay set:
|
|---|
| 87 | # S1 S2 M1 M2 MeV1 Mev2
|
|---|
| 88 | ----------------------------------------------------
|
|---|
| 89 | 10 2.38 2.59 2.11 2.12 2.32 2.35
|
|---|
| 90 | 20 7.39 11.14 4.35 4.39 5.20 5.18
|
|---|
| 91 | 40 24.11 24.43 9.27 9.40 10.58 10.47
|
|---|
| 92 | 80 39.16 41.19 85.36 20.20 21.55 102.09
|
|---|
| 93 |
|
|---|
| 94 |
|
|---|
| 95 | Export 4
|
|---|
| 96 | ========
|
|---|
| 97 | Format: Serial and Matrix
|
|---|
| 98 | Fields: ch1, ch2, FG Mean (both channels)
|
|---|
| 99 |
|
|---|
| 100 | Root bioassay set:
|
|---|
| 101 | # S1 S2 M1 M2
|
|---|
| 102 | ------------------------------------
|
|---|
| 103 | 10 0.15 0.15 0.11 0.11
|
|---|
| 104 | 20 0.25 0.27 0.20 0.20
|
|---|
| 105 | 40 0.48 1.05 0.40 0.41
|
|---|
| 106 | 80 3.20 2.36 3.01 3.06
|
|---|
| 107 |
|
|---|
| 108 | Filtered bioassay set:
|
|---|
| 109 | # S1 S2 M1 M2
|
|---|
| 110 | ------------------------------------
|
|---|
| 111 | 10 0.42 1.23 0.12 0.11
|
|---|
| 112 | 20 1.40 1.07 0.26 0.24
|
|---|
| 113 | 40 1.37 1.43 0.56 0.45
|
|---|
| 114 | 80 2.57 2.57 4.43 2.11
|
|---|
| 115 |
|
|---|
| 116 |
|
|---|
| 117 | Export 5
|
|---|
| 118 | ========
|
|---|
| 119 | Format: Serial and Matrix
|
|---|
| 120 | Fields: all
|
|---|
| 121 |
|
|---|
| 122 | Root bioassay set:
|
|---|
| 123 | # S1 S2 M1 M2
|
|---|
| 124 | ------------------------------------
|
|---|
| 125 | 10 0.46 0.45 0.47 0.46
|
|---|
| 126 | 20 1.31 1.30 1.32 1.31
|
|---|
| 127 | 40 2.56 2.59 3.01 3.12
|
|---|
| 128 | 80 6.23 6.12 7.25 7.21
|
|---|
| 129 |
|
|---|
| 130 | Filtered bioassay set:
|
|---|
| 131 | # S1 S2 M1 M2
|
|---|
| 132 | ------------------------------------
|
|---|
| 133 | 10 0.45 0.45 0.47 0.46
|
|---|
| 134 | 20 1.31 1.31 1.36 1.34
|
|---|
| 135 | 40 2.58 2.58 3.06 3.03
|
|---|
| 136 | 80 6.35 6.39 9.33 8.08
|
|---|
| 137 |
|
|---|
| 138 |
|
|---|
| 139 | Export 6
|
|---|
| 140 | ========
|
|---|
| 141 | Format: Serial and Matrix
|
|---|
| 142 | Fields: all
|
|---|
| 143 | Reporter: all
|
|---|
| 144 |
|
|---|
| 145 | Root bioassay set:
|
|---|
| 146 | # S1 S2 M1 M2
|
|---|
| 147 | -------------------------------------
|
|---|
| 148 | 10 3.00 3.01 2.41 2.44
|
|---|
| 149 | 20 5.54 5.59 5.23 5.18
|
|---|
| 150 | 40 11.50 14.02 10.47 13.49
|
|---|
| 151 | 80 24.37 24.30 25.47 25.45
|
|---|
| 152 |
|
|---|
| 153 | Filtered bioassay set:
|
|---|
| 154 | # S1 S2 M1 M2
|
|---|
| 155 | -------------------------------------
|
|---|
| 156 | 10 3.17 4.03 2.29 2.29
|
|---|
| 157 | 20 12.36 12.02 5.14 5.26
|
|---|
| 158 | 40 24.52 26.55 10.32 10.54
|
|---|
| 159 | 80 53.25 52.05 28.38 88.38
|
|---|
| 160 |
|
|---|
