RUN-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase
上传用户:tsgydb
上传日期:2007-04-14
资源大小:10674k
文件大小:4k
源码类别:
MySQL数据库
开发平台:
Visual C++
- 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 ++++++++