diff options
Diffstat (limited to 'sql-bench/Results-win32/RUN-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase')
-rw-r--r-- | sql-bench/Results-win32/RUN-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase | 60 |
1 files changed, 60 insertions, 0 deletions
diff --git a/sql-bench/Results-win32/RUN-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/RUN-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..91a519b208c --- /dev/null +++ b/sql-bench/Results-win32/RUN-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,60 @@ +Benchmark DBD suit: 2.0 +Date of test: 1999-03-08 10:55:47 +Running tests on: Windows NT Version 4.0 +Arguments: --force +Comments: +Limits from: db2,informix,ms-sql,mysql,oracle,solid,sybase +Server version: MySQL 3.22.16 gamma + +ATIS: Total time: 71 wallclock secs (16.88 usr + 8.22 sys = 25.11 CPU) +alter-table: Total time: 5 wallclock secs ( 0.19 usr + 0.17 sys = 0.36 CPU) +big-tables: Total time: 74 wallclock secs (23.40 usr + 8.04 sys = 31.45 CPU) +connect: Total time: 155 wallclock secs (45.74 usr + 33.56 sys = 79.29 CPU) +create: Total time: 72 wallclock secs ( 2.05 usr + 0.97 sys = 3.02 CPU) +insert: Total time: 5368 wallclock secs (568.77 usr + 216.27 sys = 785.04 CPU) +select: Estimated total time: 899 wallclock secs (90.43 usr + 24.97 sys = 115.41 CPU) +wisconsin: Total time: 38 wallclock secs ( 7.83 usr + 5.25 sys = 13.08 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.01 0.00 0.01 8 +connect 56 16.91 13.01 29.92 10000 +connect+select 64 18.76 14.96 33.72 10000 +count 54 0.06 0.01 0.07 100 +count_key 665 36.67 9.66 46.33 50000 + +count_on_key 31 0.08 0.04 0.12 100 +create+drop 14 0.40 0.19 0.59 1000 +create_index 2 0.00 0.00 0.00 8 +create_key+drop 18 0.85 0.33 1.18 1000 +create_table 23 0.47 0.19 0.66 1031 +delete_big 678 0.01 0.00 0.01 15 +delete_key 1 0.10 0.08 0.18 500 +drop_index 1 0.00 0.00 0.00 8 +drop_table 3 0.10 0.18 0.28 1028 +insert 381 67.34 48.27 115.61 350768 +insert_duplicates 68 16.34 13.36 29.70 300000 +insert_key 2906 27.77 14.64 42.41 100000 +insert_many_fields 30 7.32 2.84 10.16 20000 +min_max 26 0.06 0.01 0.07 60 +min_max_on_key 220 51.97 14.10 66.07 73000 +order_by 100 40.72 19.97 60.69 10 +order_by_key 73 40.79 20.33 61.12 10 +select 21 3.50 3.78 7.30 20000 +select_big 88 47.93 21.83 69.76 10080 +select_distinct 17 3.22 1.51 4.74 800 +select_group 53 2.23 0.70 2.93 3191 +select_join 31 8.80 4.19 12.99 200 +select_key 367 157.27 40.25 197.51 200000 +select_key_prefix 375 158.15 38.91 197.05 200000 +select_many_fields 44 16.07 5.19 21.28 20000 +select_range 40 13.94 3.73 17.68 25400 +select_range_prefix 34 12.64 3.04 15.68 25000 +select_simple_join 3 1.23 0.50 1.73 500 +update_key 0 0.09 0.05 0.14 500 +update_key_big 26 0.10 0.06 0.16 501 +update_of_key 157 0.04 0.04 0.08 256 +wisc_benchmark 8 3.07 1.29 4.37 114 +TOTALS 6679 755.01 297.24 1052.30 1425188 + |