RUN-pg-Linux_2.0.36_i686-cmp-mysql,pg,solid
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:4k
源码类别:
MySQL数据库
开发平台:
Visual C++
- Benchmark DBD suite: 2.0b
- Date of test: 1999-03-09 18:59:51
- Running tests on: Linux 2.0.36 i686
- Arguments: --force
- Comments:
- Limits from: mysql,pg,solid
- Server version: PostgreSQL 6.4
- ATIS: Estimated total time: 1520 wallclock secs (16.64 usr 1.66 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
- alter-table: Total time: 4 wallclock secs ( 0.80 usr 0.07 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
- big-tables: Total time: 470 wallclock secs ( 7.63 usr 0.60 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
- connect: Total time: 349 wallclock secs (42.65 usr 10.17 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
- create: Total time: 168 wallclock secs ( 6.14 usr 0.53 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
- insert: Estimated total time: 133319 wallclock secs (625.54 usr 64.54 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
- select: Estimated total time: 2069 wallclock secs (51.44 usr 5.76 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs)
- wisconsin: Total time: 452 wallclock secs (22.00 usr 2.22 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 1 0.15 0.00 0.00 293
- connect 84 9.71 2.81 0.00 10000
- connect+select 210 17.17 5.07 0.00 10000
- count 156 0.04 0.01 0.00 100
- count_on_key 1685 27.36 3.43 0.00 50100 +
- create+drop 46 1.86 0.23 0.00 1000
- create_index 1 0.00 0.00 0.00 7
- create_key+drop 33 1.56 0.14 0.00 1000
- create_table 68 1.54 0.11 0.00 1031
- delete_big 76 0.01 0.00 0.00 15
- delete_key 634 0.32 0.09 0.00 500
- drop_index 0 0.00 0.00 0.00 7
- drop_table 17 0.62 0.03 0.00 1028
- insert 1213 198.22 22.62 0.00 350768
- insert_duplicates 164 46.42 5.41 0.00 300000
- insert_key 944 57.30 6.79 0.00 100000
- insert_many_fields 123 1.37 0.14 0.00 2000
- min_max 49 0.04 0.00 0.00 60
- min_max_on_key 2153 18.34 1.75 0.00 73000 +
- order_by 269 26.89 1.27 0.00 10
- order_by_key 265 26.66 1.20 0.00 10
- select 35 10.00 1.13 0.00 20000
- select_big 136 32.59 2.75 0.00 10080
- select_distinct 139 2.82 0.22 0.00 800
- select_group 5688 2.22 0.22 0.00 3101
- select_join 1262 5.94 0.52 0.00 200 +
- select_key 634 122.95 13.45 0.00 200000 +
- select_key_prefix 639 123.46 13.29 0.00 200000 +
- select_many_fields 347 6.25 0.46 0.00 2000
- select_range 34472 3.80 0.07 0.00 25410 ++
- select_range_prefix 34462 6.24 0.56 0.00 25000 ++
- select_simple_join 6 1.02 0.10 0.00 500
- update_key 443 0.23 0.03 0.00 500
- update_key_big 978 0.34 0.06 0.00 501
- update_of_key 3569 0.14 0.03 0.00 256
- wisc_benchmark 310 5.05 0.37 0.00 114
- TOTALS 91311 758.63 84.36 0.00 1389391 +++++++++