diff options
Diffstat (limited to 'sql-bench/Results-win32/RUN-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase')
| -rw-r--r-- | sql-bench/Results-win32/RUN-ms-sql_odbc-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-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/RUN-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..b08b487e1f4 --- /dev/null +++ b/sql-bench/Results-win32/RUN-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,60 @@ +Benchmark DBD suit: 2.0 +Date of test: 1998-09-27 10:54:51 +Running tests on: Windows NT Version 4.0 +Arguments: --force +Comments: +Limits from: db2,informix,ms-sql,mysql,oracle,solid,sybase +Server version: Microsoft SQL Server 7.00 - 7.00.517 (Intel X86) + +alter-table: Total time: 7 secs ( 7.50 usr 0.00 sys = 7.50 cpu) +ATIS: Total time: 231 secs (230.45 usr 0.00 sys = 230.45 cpu) +big-tables: Total time: 155 secs (154.44 usr 0.00 sys = 154.44 cpu) +connect: Total time: 535 secs (534.85 usr 0.00 sys = 534.85 cpu) +create: Total time: 152 secs (151.76 usr 0.00 sys = 151.76 cpu) +insert: Estimated total time: 15454 secs (15453.34 usr 0.00 sys = 15453.34 cpu) +select: Estimated total time: 1186 secs (1185.72 usr 0.00 sys = 1185.72 cpu) +wisconsin: Total time: 290 secs (290.80 usr 0.00 sys = 290.80 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 0 0.04 0.00 0.04 8 +connect 202 201.91 0.00 201.91 10000 +connect+select 234 234.54 0.00 234.54 10000 +count 49 49.15 0.00 49.15 100 +count_key 763 762.84 0.00 762.84 50000 + +count_on_key 18 17.22 0.00 17.22 100 +create+drop 35 34.23 0.00 34.23 1000 +create_index 1 0.64 0.00 0.64 8 +create_key+drop 36 36.10 0.00 36.10 1000 +create_table 56 57.17 0.00 57.17 1031 +delete_big 877 877.05 0.00 877.05 15 +delete_key 21 21.33 0.00 21.33 500 +drop_index 0 0.07 0.00 0.07 8 +drop_table 7 6.87 0.00 6.87 1028 +insert 4012 4011.32 0.00 4011.32 350768 +insert_duplicates 286 285.70 0.00 285.70 300000 +insert_key 5181 5181.56 0.00 5181.56 100000 +insert_many_fields 76 75.76 0.00 75.76 20000 +min_max 115 115.58 0.00 115.58 60 +min_max_on_key 333 332.78 0.00 332.78 73000 +order_by 250 250.66 0.00 250.66 10 +order_by_key 201 200.90 0.00 200.90 10 +select 65 64.78 0.00 64.78 20000 +select_big 238 237.78 0.00 237.78 10080 +select_distinct 59 59.65 0.00 59.65 800 +select_group 126 126.06 0.00 126.06 3191 +select_join 66 65.25 0.00 65.25 200 +select_key 1634 1634.55 0.00 1634.55 200000 + +select_key_prefix 1698 1696.55 0.00 1696.55 200000 + +select_many_fields 78 78.61 0.00 78.61 20000 +select_range 87 86.24 0.00 86.24 25400 +select_range_prefix 68 69.08 0.00 69.08 25000 +select_simple_join 8 8.30 0.00 8.30 500 +update_key 8 8.00 0.00 8.00 500 +update_key_big 403 402.89 0.00 402.89 501 +update_of_key 674 674.29 0.00 674.29 256 +wisc_benchmark 24 23.97 0.00 23.97 114 +TOTALS 17989 17989.42 0.00 17989.42 1425188 +++ |