blob: 4dc95282073e64651bf66116565d12188b697d44 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
Benchmark DBD suit: 2.0
Date of test: 1998-09-24 15:16:40
Running tests on: Linux 2.0.35 i686
Arguments: --small-tables
Comments:
Limits from: adabas,mysql
Server version: Adabas 10.01.00
ATIS: Total time: 445 secs (41.77 usr 50.26 sys = 92.03 cpu)
alter-table: Total time: 40 secs ( 0.76 usr 0.47 sys = 1.23 cpu)
big-tables: Total time: 89 secs ( 8.81 usr 10.98 sys = 19.79 cpu)
connect: Total time: 570 secs (65.81 usr 250.86 sys = 316.67 cpu)
create: Total time: 348 secs ( 2.35 usr 7.46 sys = 9.81 cpu)
insert: Estimated total time: 11695 secs ( 249.00 463.00 713.00)
select: Estimated total time: 3338 secs (87.31 usr 141.31 sys = 228.62 cpu)
wisconsin: Total time: 654 secs (34.14 usr 21.26 sys = 55.40 cpu)
All 8 test executed successfully
Tests with estimated time have a + at end of line
Totals per operation:
Operation seconds usr sys cpu tests
alter_table_add 11 0.07 0.10 0.17 246
alter_table_drop 8 0.01 0.08 0.09 123
connect 164 29.40 100.88 130.28 10000
connect+select 295 22.17 121.92 144.09 10000
count 107 0.11 0.12 0.23 100
count_on_key 760 28.47 56.52 84.99 50100 +
create+drop 126 0.25 2.57 2.82 1000
create_index 1 0.00 0.00 0.00 8
create_key+drop 97 0.27 2.86 3.13 1000
create_table 48 1.48 0.63 2.11 1031
delete_big 17 0.02 0.01 0.03 15
delete_key 48 0.39 0.35 0.74 500
drop_index 1 0.00 0.00 0.00 8
drop_table 78 0.12 0.64 0.76 1028
insert 1669 55.14 18.59 73.73 80768
insert_duplicates 9 3.57 3.81 7.38 30000
insert_key 241 8.58 2.07 10.65 10000
insert_many_fields 54 0.73 1.52 2.25 2000
min_max 40 0.09 0.09 0.18 60
min_max_on_key 2421 46.26 76.81 123.06 73000 +
order_by 54 12.73 11.78 24.51 10
order_by_key 48 13.45 11.16 24.61 10
select 63 7.83 16.02 23.85 20000
select_big 89 21.11 23.12 44.23 10080
select_distinct 95 6.59 14.43 21.02 800
select_group 180 4.37 8.47 12.84 3401
select_join 74 22.10 21.09 43.19 200
select_key 1646 16.74 27.42 44.15 20000 +
select_key_prefix 79 11.74 21.54 33.28 20000
select_many_fields 35 8.08 9.45 17.53 2000
select_range 5123 16.41 26.30 42.71 25410 ++
select_range_prefix 1782 14.73 26.43 41.15 25000 +
select_simple_join 14 2.35 4.08 6.43 500
update_key 51 0.32 0.40 0.72 500
update_key_big 77 0.29 0.33 0.62 480
update_of_key 17 0.10 0.16 0.26 256
wisc_benchmark 64 15.03 14.19 29.22 114
TOTALS 15686 371.10 625.94 997.01 399748 ++++++
|
