📄 run-oracle_odbc-nt_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase
字号:
Benchmark DBD suite: 2.0b
Date of test: 1999-04-03 22:29:52
Running tests on: Windows NT Version 4.0
Arguments: --force
Comments:
Limits from: db2,informix,ms-sql,mysql,oracle,solid,sybase
Server version: Oracle 8.0.4.0.0
ATIS: Total time: 486 wallclock secs (185.81 usr 33.07 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
alter-table: Total time: 8 wallclock secs ( 1.15 usr 0.10 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
big-tables: Total time: 246 wallclock secs (93.94 usr 13.29 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
connect: Total time: 17520 wallclock secs (504.84 usr 806.71 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
create: Total time: 947 wallclock secs (15.04 usr 1.62 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
insert: Estimated total time: 114468 wallclock secs (3850.94 usr 602.34 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
select: Estimated total time: 2147 wallclock secs (304.96 usr 63.03 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
wisconsin: Total time: 335 wallclock secs (86.43 usr 10.31 sys + 0.00 cusr 0.00 csys = 0.00 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 1 0.00 0.00 0.00 8
connect 8713 195.47 436.40 0.00 10000
connect+select 8722 257.48 362.71 0.00 10000
count 51 0.30 0.04 0.00 100
count_on_key 869 118.48 25.29 0.00 50100 +
create+drop 288 4.23 0.58 0.00 1000
create_index 0 0.00 0.00 0.00 8
create_key+drop 411 4.65 0.38 0.00 1000
create_table 135 3.45 0.41 0.00 1031
delete_big 784 0.09 0.18 0.00 15
delete_key 628 0.70 0.16 0.00 500
drop_index 1 0.01 0.02 0.00 8
drop_table 112 1.34 0.17 0.00 1028
insert 2924 493.77 58.70 0.00 350768
insert_duplicates 353 195.15 26.95 0.00 300000
insert_key 1293 151.81 16.58 0.00 100000
insert_many_fields 150 29.55 3.33 0.00 20000
min_max 25 0.22 0.03 0.00 60
min_max_on_key 1181 165.25 35.39 0.00 73000 +
order_by 1098 570.85 95.67 0.00 10 +
order_by_key 1125 580.64 95.55 0.00 10 +
select 47 30.58 2.91 0.00 20000
select_big 1174 599.95 105.18 0.00 10080
select_distinct 79 37.62 6.46 0.00 800
select_group 82 11.18 2.22 0.00 3191
select_join 255 112.16 20.68 0.00 200
select_key 86849 639.74 105.64 0.00 200000 +
select_key_prefix 1037 576.33 93.13 0.00 200000 +
select_many_fields 96 64.39 9.96 0.00 20000
select_range 8072 36.50 5.27 0.00 25400 ++
select_range_prefix 95 58.76 8.18 0.00 25000
select_simple_join 28 13.20 2.31 0.00 500
update_key 220 0.76 0.07 0.00 500
update_key_big 429 0.83 0.20 0.00 501
update_of_key 568 0.30 0.06 0.00 256
wisc_benchmark 82 44.61 5.10 0.00 114
TOTALS 127977 5000.35 1525.91 0.00 1425188 ++++++++
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -