Ticket #294: perftest.txt

File perftest.txt, 819 bytes (added by Nicklas Nordborg, 15 years ago)

Test results when running with/without index on primary key columns

Line 
1MySQL 5.0.37-community-nt-log
2BASE 2.5.0pre (build #3795; schema #43)
3
4Using internal job queue: times = started - ended (seconds)
5K1, K2 - with original index on primary key columns
6K3, K4 - without index
7
8Root bioassayset, 36232 spots, Median FG - Median BG
9----------------------------------------------------
10Antal, K1, K2, K3, K4
1110, 49, 131, 25, 17
1220, 69, 133, 35, 35
1330, 105, 560, 61, 48
1440, 261, 579, 69, 64
15
16
17Filter, ch(1) > 0 && ch(2) > 0 && raw('flag') == 0
18--------------------------------------------------
19Antal, K1, K2, K3, K4
2010, 35, -, 17, -
2120, 50, -, 31, -
2230, 84, -, 45, -
2340, 138, -, 67, -
24
25
26Lowess, step=0.1, window size=0.33, iterations=4, blockgroup size=1
27-------------------------------------------------------------------
28Antal, K1, K2, K3, K4
2910, 707, -, 613
3020, -, -,
3130, -, -,
3240, -, -,
33