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