blob: 572ddd0e3b029d820c4dc3d332651ec4992d7ad4 (
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
|
Benchmark DBD suite: 2.0b
Date of test: 1999-03-23 8:05:45
Running tests on: Linux 2.0.36 i686
Arguments: --force --fast
Comments:
Limits from: mysql,oracle
Server version: Oracle 8.0.5.0.0
ATIS: Total time: 396 wallclock secs (124.50 usr 29.24 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
alter-table: Total time: 13 wallclock secs ( 1.14 usr 0.11 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
big-tables: Total time: 49 wallclock secs (12.68 usr 0.78 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
connect: Total time: 49 wallclock secs (12.68 usr 0.78 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
create: Total time: 611 wallclock secs (11.43 usr 1.28 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
insert: Estimated total time: 124637 wallclock secs (1926.54 usr 389.27 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
select: Estimated total time: 2285 wallclock secs (259.15 usr 54.33 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
wisconsin: Total time: 190 wallclock secs (53.06 usr 7.56 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
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 8 0.31 0.02 0.00 246
book-keeping 362 1.79 0.26 0.00 34
count 50 0.10 0.04 0.00 100
count_on_key 813 56.44 12.01 0.00 50100 +
create+drop 198 2.72 0.37 0.00 1000
create_index 0 0.01 0.00 0.00 8
create_key+drop 174 3.64 0.28 0.00 1000
create_table 108 1.93 0.18 0.00 1031
delete_big 1475 0.06 0.06 0.00 15
delete_key 262 0.31 0.03 0.00 500
drop_index 1 0.00 0.00 0.00 8
drop_table 88 0.71 0.04 0.00 1028
insert 1357 259.88 32.29 0.00 350768
insert_duplicates 2001 0.00 0.00 0.00 300000
insert_key 677 78.14 9.36 0.00 100000
insert_many_fields 7 2.04 0.14 0.00 2000
min_max 25 0.09 0.02 0.00 60
min_max_on_key 890 78.61 16.96 0.00 73000 +
order_by 807 349.92 85.42 0.00 10 +
order_by_key 856 370.12 85.01 0.00 10 +
select_big 861 368.26 96.12 0.00 80
select_distinct 56 24.55 5.45 0.00 800
select_group 94 13.03 2.94 0.00 3391
select_join 188 71.78 18.08 0.00 200
select_key 91615 228.66 33.54 0.00 200000 +
select_key_prefix 753 235.02 39.45 0.00 200000 +
select_many_fields 40 10.55 0.64 0.00 2000
select_range 15390 137.88 27.54 0.00 25410 ++
select_range_prefix 84 35.44 6.75 0.00 25010
select_simple_join 20 8.26 1.90 0.00 500
update_key 223 0.31 0.02 0.00 500
update_key_big 302 0.45 0.10 0.00 501
update_of_key 601 0.18 0.00 0.00 256
wisc_benchmark 63 30.34 4.90 0.00 114
TOTALS 120449 2371.53 479.92 0.00 1339680 ++++++++
|