diff options
Diffstat (limited to 'sql-bench/Results-win32')
97 files changed, 2940 insertions, 0 deletions
diff --git a/sql-bench/Results-win32/ATIS-access_odbc-win98-cmp-access,mysql b/sql-bench/Results-win32/ATIS-access_odbc-win98-cmp-access,mysql new file mode 100644 index 00000000000..2a20462392c --- /dev/null +++ b/sql-bench/Results-win32/ATIS-access_odbc-win98-cmp-access,mysql @@ -0,0 +1,19 @@ +Testing server 'Access 2000' at 2000-01-03 3:59:36
+
+ATIS table test
+
+Creating tables
+Time for create_table (28): 1 wallclock secs ( 0.50 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Inserting data
+Time to insert (9768): 58 wallclock secs (58.44 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Retrieving data
+Time for select_simple_join (500): 12 wallclock secs (11.59 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_join (200): 82 wallclock secs (81.89 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_distinct (800): 46 wallclock secs (46.14 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_group (2400): 42 wallclock secs (42.24 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Removing tables
+Time to drop_table (28): 0 wallclock secs ( 0.16 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Total time: 241 wallclock secs (241.02 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/ATIS-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/ATIS-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..854f3cb2fd1 --- /dev/null +++ b/sql-bench/Results-win32/ATIS-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,19 @@ +Testing server 'IBM DB2 5' at 1998-11-21 23:09:24 + +ATIS table test + +Creating tables +Time for create_table (28): 47 secs (46.89 usr 0.00 sys = 46.89 cpu) + +Inserting data +Time to insert (9768): 101 secs (101.33 usr 0.00 sys = 101.33 cpu) + +Retrieving data +Time for select_simple_join (500): 26 secs (26.36 usr 0.00 sys = 26.36 cpu) +Time for select_join (200): 225 secs (224.28 usr 0.00 sys = 224.28 cpu) +Time for select_distinct (800): 82 secs (82.50 usr 0.00 sys = 82.50 cpu) +Time for select_group (2100): 32 secs (31.38 usr 0.00 sys = 31.38 cpu) + +Removing tables +Time to drop_table (28): 1 secs ( 1.23 usr 0.00 sys = 1.23 cpu) +Total time: 515 secs (514.66 usr 0.00 sys = 514.66 cpu) diff --git a/sql-bench/Results-win32/ATIS-informix_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/ATIS-informix_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..d5fc3965902 --- /dev/null +++ b/sql-bench/Results-win32/ATIS-informix_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,19 @@ +Testing server 'Informix 7.30C1 ' at 1998-09-01 2:00:37 + +ATIS table test + +Creating tables +Time for create_table (28): 3 secs ( 2.81 usr 0.00 sys = 2.81 cpu) + +Inserting data +Time to insert (9768): 53 secs (52.98 usr 0.00 sys = 52.98 cpu) + +Retrieving data +Time for select_simple_join (500): 22 secs (21.83 usr 0.00 sys = 21.83 cpu) +Time for select_join (200): 99 secs (98.99 usr 0.00 sys = 98.99 cpu) +Time for select_distinct (800): 97 secs (97.37 usr 0.00 sys = 97.37 cpu) +Time for select_group (2100): 59 secs (58.55 usr 0.00 sys = 58.55 cpu) + +Removing tables +Time to drop_table (28): 0 secs ( 0.78 usr 0.00 sys = 0.78 cpu) +Total time: 333 secs (333.33 usr 0.00 sys = 333.33 cpu) diff --git a/sql-bench/Results-win32/ATIS-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/ATIS-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..061447969d9 --- /dev/null +++ b/sql-bench/Results-win32/ATIS-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,19 @@ +Testing server 'Microsoft SQL Server 7.00 - 7.00.517 (Intel X86) ' at 1998-09-07 2:15:22 + +ATIS table test + +Creating tables +Time for create_table (28): 1 secs ( 1.21 usr 0.00 sys = 1.21 cpu) + +Inserting data +Time to insert (9768): 65 secs (64.59 usr 0.00 sys = 64.59 cpu) + +Retrieving data +Time for select_simple_join (500): 8 secs ( 8.30 usr 0.00 sys = 8.30 cpu) +Time for select_join (200): 66 secs (65.25 usr 0.00 sys = 65.25 cpu) +Time for select_distinct (800): 59 secs (59.65 usr 0.00 sys = 59.65 cpu) +Time for select_group (2100): 31 secs (30.33 usr 0.00 sys = 30.33 cpu) + +Removing tables +Time to drop_table (28): 1 secs ( 1.07 usr 0.00 sys = 1.07 cpu) +Total time: 231 secs (230.45 usr 0.00 sys = 230.45 cpu) diff --git a/sql-bench/Results-win32/ATIS-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/ATIS-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..8b5cd5d24c9 --- /dev/null +++ b/sql-bench/Results-win32/ATIS-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,19 @@ +Testing server 'MySQL 3.22.16 gamma' at 1999-02-20 19:53:01 + +ATIS table test + +Creating tables +Time for create_table (28): 0 wallclock secs ( 0.00 usr + 0.01 sys = 0.01 CPU) + +Inserting data +Time to insert (9768): 8 wallclock secs ( 1.66 usr + 1.41 sys = 3.07 CPU) + +Retrieving data +Time for select_simple_join (500): 3 wallclock secs ( 1.23 usr + 0.50 sys = 1.73 CPU) +Time for select_join (200): 31 wallclock secs ( 8.80 usr + 4.19 sys = 12.99 CPU) +Time for select_distinct (800): 17 wallclock secs ( 3.22 usr + 1.51 sys = 4.74 CPU) +Time for select_group (2100): 12 wallclock secs ( 1.95 usr + 0.58 sys = 2.53 CPU) + +Removing tables +Time to drop_table (28): 0 wallclock secs ( 0.00 usr + 0.02 sys = 0.02 CPU) +Total time: 71 wallclock secs (16.88 usr + 8.22 sys = 25.11 CPU) diff --git a/sql-bench/Results-win32/ATIS-mysql-win98 b/sql-bench/Results-win32/ATIS-mysql-win98 new file mode 100644 index 00000000000..1febfa34bcb --- /dev/null +++ b/sql-bench/Results-win32/ATIS-mysql-win98 @@ -0,0 +1,19 @@ +Testing server 'MySQL 3.23.13a alpha' at 2000-03-15 2:22:09
+
+ATIS table test
+
+Creating tables
+Time for create_table (28): 7 wallclock secs ( 6.93 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Inserting data
+Time to insert (9768): 12 wallclock secs (11.97 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Retrieving data
+Time for select_simple_join (500): 7 wallclock secs ( 7.47 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_join (200): 51 wallclock secs (50.15 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_distinct (800): 33 wallclock secs (33.34 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_group (2800): 33 wallclock secs (33.61 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Removing tables
+Time to drop_table (28): 1 wallclock secs ( 0.06 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Total time: 144 wallclock secs (143.53 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/ATIS-mysql-win98-cmp-access,mysql b/sql-bench/Results-win32/ATIS-mysql-win98-cmp-access,mysql new file mode 100644 index 00000000000..35e02bc97f0 --- /dev/null +++ b/sql-bench/Results-win32/ATIS-mysql-win98-cmp-access,mysql @@ -0,0 +1,19 @@ +Testing server 'MySQL 3.23.8 alpha' at 2000-01-04 12:17:54
+
+ATIS table test
+
+Creating tables
+Time for create_table (28): 0 wallclock secs ( 0.22 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Inserting data
+Time to insert (9768): 15 wallclock secs (15.48 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Retrieving data
+Time for select_simple_join (500): 9 wallclock secs ( 8.35 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_join (200): 51 wallclock secs (51.25 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_distinct (800): 36 wallclock secs (36.52 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_group (2100): 23 wallclock secs (22.96 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Removing tables
+Time to drop_table (28): 0 wallclock secs ( 0.06 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Total time: 134 wallclock secs (134.84 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/ATIS-mysql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/ATIS-mysql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..d0ab9a21940 --- /dev/null +++ b/sql-bench/Results-win32/ATIS-mysql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,19 @@ +Testing server 'MySQL 3.22.16 gamma' at 1999-02-07 11:41:12 + +ATIS table test + +Creating tables +Time for create_table (28): 1 secs ( 0.17 usr 0.00 sys = 0.17 cpu) + +Inserting data +Time to insert (9768): 15 secs (15.52 usr 0.00 sys = 15.52 cpu) + +Retrieving data +Time for select_simple_join (500): 10 secs ( 9.62 usr 0.00 sys = 9.62 cpu) +Time for select_join (200): 91 secs (90.99 usr 0.00 sys = 90.99 cpu) +Time for select_distinct (800): 35 secs (35.07 usr 0.00 sys = 35.07 cpu) +Time for select_group (2100): 16 secs (15.83 usr 0.00 sys = 15.83 cpu) + +Removing tables +Time to drop_table (28): 0 secs ( 0.07 usr 0.00 sys = 0.07 cpu) +Total time: 168 secs (167.31 usr 0.00 sys = 167.31 cpu) diff --git a/sql-bench/Results-win32/ATIS-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/ATIS-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..c33c525126c --- /dev/null +++ b/sql-bench/Results-win32/ATIS-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,19 @@ +Testing server 'Oracle 8.0.4.0.0' at 1999-04-03 22:29:55
+
+ATIS table test
+
+Creating tables
+Time for create_table (28): 3 wallclock secs ( 0.11 usr 0.03 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Inserting data
+Time to insert (9768): 87 wallclock secs (13.15 usr 1.56 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Retrieving data
+Time for select_simple_join (500): 28 wallclock secs (13.20 usr 2.31 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_join (200): 255 wallclock secs (112.16 usr 20.68 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_distinct (800): 79 wallclock secs (37.62 usr 6.46 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_group (2100): 30 wallclock secs ( 9.51 usr 2.02 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Removing tables
+Time to drop_table (28): 4 wallclock secs ( 0.03 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Total time: 486 wallclock secs (185.81 usr 33.07 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/ATIS-solid_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/ATIS-solid_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..4935821fd48 --- /dev/null +++ b/sql-bench/Results-win32/ATIS-solid_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,22 @@ +Testing server 'Solid version ???' at 1998-10-06 17:43:41 + +ATIS table test + +Creating tables +Time for create_table (28): 2 secs ( 1.80 usr 0.00 sys = 1.80 cpu) + +Inserting data +Time to insert (9768): 45 secs (45.27 usr 0.00 sys = 45.27 cpu) + +Retrieving data +Time for select_simple_join (500): 69 secs (69.48 usr 0.00 sys = 69.48 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +172 queries in 86 loops of 100 loops took 601 seconds +Estimated time for select_join (200): 698 secs (698.11 usr 0.00 sys = 698.11 cpu) +Time for select_distinct (800): 327 secs (327.14 usr 0.00 sys = 327.14 cpu) +Time for select_group (2100): 105 secs (105.28 usr 0.00 sys = 105.28 cpu) + +Removing tables +Time to drop_table (28): 2 secs ( 1.68 usr 0.00 sys = 1.68 cpu) +Estimated total time: 1248 secs (1248.81 usr 0.00 sys = 1248.81 cpu) diff --git a/sql-bench/Results-win32/ATIS-sybase_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/ATIS-sybase_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..40c0f169f40 --- /dev/null +++ b/sql-bench/Results-win32/ATIS-sybase_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,19 @@ +Testing server 'Sybase enterprise 11.5 NT' at 1998-08-27 2:08:30 + +ATIS table test + +Creating tables +Time for create_table (28): 2 secs ( 1.41 usr 0.00 sys = 1.41 cpu) + +Inserting data +Time to insert (9768): 120 secs (120.34 usr 0.00 sys = 120.34 cpu) + +Retrieving data +Time for select_simple_join (500): 17 secs (16.86 usr 0.00 sys = 16.86 cpu) +Time for select_join (200): 114 secs (114.63 usr 0.00 sys = 114.63 cpu) +Time for select_distinct (800): 64 secs (63.34 usr 0.00 sys = 63.34 cpu) +Time for select_group (2100): 21 secs (21.00 usr 0.00 sys = 21.00 cpu) + +Removing tables +Time to drop_table (28): 0 secs ( 0.31 usr 0.00 sys = 0.31 cpu) +Total time: 338 secs (337.94 usr 0.00 sys = 337.94 cpu) diff --git a/sql-bench/Results-win32/RUN-access_odbc-win98-cmp-access,mysql b/sql-bench/Results-win32/RUN-access_odbc-win98-cmp-access,mysql new file mode 100644 index 00000000000..58dbaa500e3 --- /dev/null +++ b/sql-bench/Results-win32/RUN-access_odbc-win98-cmp-access,mysql @@ -0,0 +1,68 @@ +Benchmark DBD suite: 2.5
+Date of test: 2000-01-06 2:01:10
+Running tests on: Windows 98 [Version 4.10.1998]
+Arguments:
+Comments:
+Limits from: access,mysql
+Server version: Access 2000
+
+alter-table: Total time: 8 wallclock secs ( 8.02 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+ATIS: Total time: 241 wallclock secs (241.02 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+big-tables: Total time: 457 wallclock secs (457.69 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+connect: Total time: 5012 wallclock secs (5011.52 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+create: Total time: 699 wallclock secs (698.76 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+insert: Estimated total time: 39293 wallclock secs (39294.15 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+select: Estimated total time: 1710 wallclock secs (1710.98 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+wisconsin: Total time: 282 wallclock secs (281.60 usr 0.00 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
+Tests with didn't return the correct result have a ? at end of line
+
+Totals per operation:
+Operation seconds usr sys cpu tests
+alter_table_add 1 1.15 0.00 0.00 247
+alter_table_drop 1 0.71 0.00 0.00 124
+connect 1267 1267.63 0.00 0.00 10000
+connect+select_1_row 1780 1779.92 0.00 0.00 10000 ?
+connect+select_simpl 1766 1765.08 0.00 0.00 10000
+count 328 327.46 0.00 0.00 100
+count_on_key 460 460.61 0.00 0.00 50100
+create+drop 187 186.36 0.00 0.00 7000
+create_index 0 0.11 0.00 0.00 8
+create_key+drop 207 207.73 0.00 0.00 7000
+create_many_tables 142 141.43 0.00 0.00 7000
+create_table 2 0.67 0.00 0.00 31
+delete_big 276 275.57 0.00 0.00 13
+delete_big_many_keys 12569 12568.66 0.00 0.00 2
+delete_key 79 79.31 0.00 0.00 500
+drop_index 0 0.06 0.00 0.00 8
+drop_table 109 109.79 0.00 0.00 7028
+insert 2347 2347.51 0.00 0.00 350768
+insert_duplicates 209 208.61 0.00 0.00 300000
+insert_key 10591 10591.45 0.00 0.00 100000
+insert_many_fields 124 124.51 0.00 0.00 2000
+min_max 186 186.25 0.00 0.00 60
+min_max_on_key 1148 1148.04 0.00 0.00 73000 +
+order_by 388 388.10 0.00 0.00 10
+order_by_key 396 395.80 0.00 0.00 10
+select_1_row 55 55.04 0.00 0.00 10000
+select_2_rows 56 55.81 0.00 0.00 10000
+select_big 365 364.81 0.00 0.00 10080
+select_diff_key 3 3.63 0.00 0.00 500
+select_distinct 46 46.14 0.00 0.00 800
+select_group 435 436.28 0.00 0.00 9491
+select_join 82 81.89 0.00 0.00 200
+select_key 2064 2064.23 0.00 0.00 200000 +
+select_key_prefix 1674 1673.75 0.00 0.00 200000 +
+select_many_fields 320 319.89 0.00 0.00 2000
+select_range 603 602.54 0.00 0.00 25420
+select_range_prefix 2091 2092.64 0.00 0.00 25010 +
+select_simple 38 38.12 0.00 0.00 10000
+select_simple_join 12 11.59 0.00 0.00 500
+update_big 1550 1550.11 0.00 0.00 500
+update_of_key 887 887.11 0.00 0.00 756
+update_of_key_big 548 548.43 0.00 0.00 501
+update_with_key 2081 2080.30 0.00 0.00 100000
+wisc_benchmark 33 33.17 0.00 0.00 114
+TOTALS 47506 47508.00 0.00 0.00 1540881 ?++++
diff --git a/sql-bench/Results-win32/RUN-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/RUN-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..8d429da7866 --- /dev/null +++ b/sql-bench/Results-win32/RUN-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,54 @@ +Benchmark DBD suit: 2.0 +Date of test: 1999-02-02 7:10:24 +Running tests on: Windows NT Version 4.0 +Arguments: --force +Comments: +Limits from: db2,informix,ms-sql,mysql,oracle,solid,sybase +Server version: IBM DB2 5 + +alter-table: Failed +ATIS: Total time: 515 secs (514.66 usr 0.00 sys = 514.66 cpu) +big-tables: Total time: 250 secs (249.43 usr 0.00 sys = 249.43 cpu) +connect: Failed +create: Total time: 1106 secs (1106.62 usr 0.00 sys = 1106.62 cpu) +insert: Estimated total time: 17508 secs (17508.04 usr 0.00 sys = 17508.04 cpu) +select: Estimated total time: 1934 secs (1934.67 usr 0.00 sys = 1934.67 cpu) +wisconsin: Total time: 368 secs (367.48 usr 0.00 sys = 367.48 cpu) + +Of 8 tests, 2 tests didn't work +Tests with estimated time have a + at end of line + +Totals per operation: +Operation seconds usr sys cpu tests +count 87 87.24 0.00 87.24 100 +count_key 753 753.46 0.00 753.46 50000 + +count_on_key 58 57.98 0.00 57.98 100 +create+drop 408 408.21 0.00 408.21 1000 +create_key+drop 193 192.75 0.00 192.75 1000 +create_table 439 439.52 0.00 439.52 1031 +delete_big 451 450.96 0.00 450.96 15 +delete_key 16 15.97 0.00 15.97 500 +drop_table 107 107.42 0.00 107.42 1028 +insert 3460 3460.94 0.00 3460.94 350768 +insert_duplicates 353 353.39 0.00 353.39 300000 +insert_key 2484 2484.63 0.00 2484.63 100000 +insert_many_fields 135 135.62 0.00 135.62 20000 +min_max 56 55.56 0.00 55.56 60 +min_max_on_key 1631 1631.00 0.00 1631.00 73000 + +order_by 361 361.08 0.00 361.08 10 +order_by_key 369 368.78 0.00 368.78 10 +select_big 383 382.60 0.00 382.60 80 +select_distinct 82 82.50 0.00 82.50 800 +select_group 184 183.57 0.00 183.57 3191 +select_join 225 224.28 0.00 224.28 200 +select_key 1206 1206.37 0.00 1206.37 200000 + +select_key_prefix 1199 1199.40 0.00 1199.40 200000 + +select_many_fields 113 112.90 0.00 112.90 20000 +select_range 2170 2168.69 0.00 2168.69 25400 ++ +select_range_prefix 2150 2151.84 0.00 2151.84 25000 ++ +select_simple_join 26 26.36 0.00 26.36 500 +update_key 5 5.24 0.00 5.24 500 +update_key_big 542 542.23 0.00 542.23 501 +update_of_key 175 174.76 0.00 174.76 256 +wisc_benchmark 32 32.10 0.00 32.10 114 +TOTALS 19853 19857.35 0.00 19857.35 1375164 ++++++++ diff --git a/sql-bench/Results-win32/RUN-informix_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/RUN-informix_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..7e8f0efd6e1 --- /dev/null +++ b/sql-bench/Results-win32/RUN-informix_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-10-05 15:25:42 +Running tests on: Windows NT Version 4.0 +Arguments: --force +Comments: +Limits from: db2,informix,ms-sql,mysql,oracle,solid,sybase +Server version: Informix 7.30C1 + +alter-table: Total time: 7 secs ( 6.60 usr 0.00 sys = 6.60 cpu) +ATIS: Total time: 333 secs (333.33 usr 0.00 sys = 333.33 cpu) +big-tables: Total time: 285 secs (285.73 usr 0.00 sys = 285.73 cpu) +connect: Total time: 4225 secs (4225.65 usr 0.00 sys = 4225.65 cpu) +create: Total time: 222 secs (221.64 usr 0.00 sys = 221.64 cpu) +insert: Estimated total time: 305853 secs (305711.97 usr 0.00 sys = 305711.97 cpu) +select: Estimated total time: 8393 secs (8391.74 usr 0.00 sys = 8391.74 cpu) +wisconsin: Total time: 219 secs (219.03 usr 0.00 sys = 219.03 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.39 0.00 0.39 8 +connect 1989 1989.51 0.00 1989.51 10000 +connect+select 2050 2049.47 0.00 2049.47 10000 +count 116 115.85 0.00 115.85 100 +count_key 7825 7824.40 0.00 7824.40 50000 + +count_on_key 931 930.38 0.00 930.38 100 +create+drop 35 35.34 0.00 35.34 1000 +create_index 1 0.44 0.00 0.44 8 +create_key+drop 90 89.37 0.00 89.37 1000 +create_table 59 58.80 0.00 58.80 1031 +delete_big 11257 11256.92 0.00 11256.92 15 +delete_key 738 737.82 0.00 737.82 500 +drop_index 0 0.10 0.00 0.10 8 +drop_table 33 33.47 0.00 33.47 1028 +insert 2692 2693.19 0.00 2693.19 350768 +insert_duplicates 280 280.34 0.00 280.34 300000 +insert_key 8231 8231.23 0.00 8231.23 100000 +insert_many_fields 111 110.94 0.00 110.94 20000 +min_max 344 344.44 0.00 344.44 60 +min_max_on_key 1083 1083.57 0.00 1083.57 73000 + +order_by 518 517.79 0.00 517.79 10 +order_by_key 485 485.49 0.00 485.49 10 +select 112 112.36 0.00 112.36 20000 +select_big 580 579.87 0.00 579.87 10080 +select_distinct 97 97.37 0.00 97.37 800 +select_group 963 962.51 0.00 962.51 3191 +select_join 99 98.99 0.00 98.99 200 +select_key 121126 120992.76 0.00 120992.76 200000 + +select_key_prefix 119960 119942.91 0.00 119942.91 200000 + +select_many_fields 174 174.64 0.00 174.64 20000 +select_range 7307 7309.74 0.00 7309.74 25400 ++ +select_range_prefix 7448 7449.00 0.00 7449.00 25000 ++ +select_simple_join 22 21.83 0.00 21.83 500 +update_key 771 771.67 0.00 771.67 500 +update_key_big 3000 2999.42 0.00 2999.42 501 +update_of_key 2190 2190.23 0.00 2190.23 256 +wisc_benchmark 45 44.91 0.00 44.91 114 +TOTALS 302762 302617.46 0.00 302617.46 1425188 ++++++++ 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 +++ 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 + diff --git a/sql-bench/Results-win32/RUN-mysql-win98 b/sql-bench/Results-win32/RUN-mysql-win98 new file mode 100644 index 00000000000..18ff522a929 --- /dev/null +++ b/sql-bench/Results-win32/RUN-mysql-win98 @@ -0,0 +1,74 @@ +Benchmark DBD suite: 2.7
+Date of test: 2000-03-15 1:51:13
+Running tests on: Windows 98 [Version 4.10.1998]
+Arguments:
+Comments: AMD K6, 400mz, 128M, 16M key_cache
+Limits from:
+Server version: MySQL 3.23.13a alpha
+
+alter-table: Total time: 1855 wallclock secs (1854.89 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+ATIS: Total time: 144 wallclock secs (143.53 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+big-tables: Total time: 151 wallclock secs (150.66 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+connect: Total time: 369 wallclock secs (368.94 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+create: Total time: 5141 wallclock secs (5140.97 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+insert: Estimated total time: 8358 wallclock secs (8356.07 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+select: Total time: 1294 wallclock secs (1293.83 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+wisconsin: Total time: 63 wallclock secs (62.40 usr 0.00 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 1046 1046.38 0.00 0.00 992
+alter_table_drop 773 772.97 0.00 0.00 496
+connect 52 51.85 0.00 0.00 10000
+connect+select_1_row 72 71.95 0.00 0.00 10000
+connect+select_simple 67 66.90 0.00 0.00 10000
+count 55 54.87 0.00 0.00 100
+count_on_key 640 639.71 0.00 0.00 50100
+create+drop 1433 1433.28 0.00 0.00 10000
+create_MANY_tables 1510 1510.83 0.00 0.00 5000
+create_index 17 16.70 0.00 0.00 8
+create_key+drop 1457 1456.57 0.00 0.00 10000
+create_table 8 7.92 0.00 0.00 31
+delete_big 23 22.25 0.00 0.00 13
+delete_big_many_keys 112 112.11 0.00 0.00 2
+delete_key 0 0.82 0.00 0.00 500
+drop_index 17 16.64 0.00 0.00 8
+drop_table 1 0.06 0.00 0.00 28
+drop_table_when_MANY_tables 160 159.83 0.00 0.00 5000
+insert 510 508.11 0.00 0.00 350768
+insert_duplicates 91 91.06 0.00 0.00 300000
+insert_key 364 363.72 0.00 0.00 100000
+insert_many_fields 25 24.71 0.00 0.00 2000
+min_max 33 32.90 0.00 0.00 60
+min_max_on_key 339 339.56 0.00 0.00 73000
+multiple_value_insert 11 11.64 0.00 0.00 100000
+order_by 249 248.87 0.00 0.00 10
+order_by_key 175 174.66 0.00 0.00 10
+outer_join 146 145.66 0.00 0.00 10
+outer_join_found 144 144.40 0.00 0.00 10
+outer_join_not_found 606 605.55 0.00 0.00 500 +
+outer_join_on_key 63 63.33 0.00 0.00 10
+select_1_row 16 15.99 0.00 0.00 10000
+select_2_rows 19 18.89 0.00 0.00 10000
+select_big 304 306.16 0.00 0.00 10080
+select_diff_key 241 240.63 0.00 0.00 500
+select_distinct 33 33.34 0.00 0.00 800
+select_group 91 91.83 0.00 0.00 2911
+select_group_when_MANY_tables 581 580.46 0.00 0.00 5000
+select_join 51 50.15 0.00 0.00 200
+select_key 540 540.35 0.00 0.00 200000
+select_key_prefix 542 542.23 0.00 0.00 200000
+select_many_fields 124 124.24 0.00 0.00 2000
+select_range 423 423.21 0.00 0.00 25420
+select_range_prefix 66 66.62 0.00 0.00 25010
+select_simple 12 12.20 0.00 0.00 10000
+select_simple_join 7 7.47 0.00 0.00 500
+update_big 84 83.33 0.00 0.00 500
+update_of_key 59 59.21 0.00 0.00 756
+update_of_key_big 38 38.07 0.00 0.00 501
+update_with_key 432 432.20 0.00 0.00 100000
+wisc_benchmark 17 17.08 0.00 0.00 114
+TOTALS 13879 13879.47 0.00 0.00 1642948 +
diff --git a/sql-bench/Results-win32/RUN-mysql-win98-cmp-access,mysql b/sql-bench/Results-win32/RUN-mysql-win98-cmp-access,mysql new file mode 100644 index 00000000000..a6858c2b2fa --- /dev/null +++ b/sql-bench/Results-win32/RUN-mysql-win98-cmp-access,mysql @@ -0,0 +1,67 @@ +Benchmark DBD suite: 2.5
+Date of test: 2000-01-05 11:04:50
+Running tests on: Windows 98 [Version 4.10.1998]
+Arguments:
+Comments: key_buffer=16M
+Limits from: access,mysql
+Server version: MySQL 3.23.8 alpha
+
+alter-table: Total time: 57 wallclock secs (57.17 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+ATIS: Total time: 134 wallclock secs (134.84 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+big-tables: Total time: 51 wallclock secs (50.91 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+connect: Total time: 276 wallclock secs (275.78 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+create: Total time: 9601 wallclock secs (9600.98 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+insert: Estimated total time: 4315 wallclock secs (4316.21 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+select: Estimated total time: 1053 wallclock secs (1053.14 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+wisconsin: Total time: 68 wallclock secs (68.32 usr 0.00 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 31 30.48 0.00 0.00 247
+alter_table_drop 21 21.25 0.00 0.00 124
+connect 55 54.76 0.00 0.00 10000
+connect+select_1_row 75 75.96 0.00 0.00 10000
+connect+select_simpl 71 70.80 0.00 0.00 10000
+count 58 57.94 0.00 0.00 100
+count_on_key 697 697.45 0.00 0.00 50100 +
+create+drop 1011 1011.13 0.00 0.00 7000
+create_index 2 2.09 0.00 0.00 8
+create_key+drop 1025 1025.23 0.00 0.00 7000
+create_many_tables 2530 2529.76 0.00 0.00 7000
+create_table 0 0.33 0.00 0.00 31
+delete_big 28 26.81 0.00 0.00 13
+delete_big_many_keys 102 102.60 0.00 0.00 2
+delete_key 1 0.93 0.00 0.00 500
+drop_index 2 1.98 0.00 0.00 8
+drop_table 316 315.72 0.00 0.00 7028
+insert 569 569.79 0.00 0.00 350768
+insert_duplicates 107 106.89 0.00 0.00 300000
+insert_key 367 367.34 0.00 0.00 100000
+insert_many_fields 8 7.91 0.00 0.00 2000
+min_max 34 33.78 0.00 0.00 60
+min_max_on_key 360 360.20 0.00 0.00 73000
+order_by 282 281.88 0.00 0.00 10
+order_by_key 192 192.79 0.00 0.00 10
+select_1_row 18 17.30 0.00 0.00 10000
+select_2_rows 20 20.65 0.00 0.00 10000
+select_big 216 216.01 0.00 0.00 10080
+select_diff_key 264 263.97 0.00 0.00 500
+select_distinct 36 36.52 0.00 0.00 800
+select_group 4781 4780.38 0.00 0.00 9191
+select_join 51 51.25 0.00 0.00 200
+select_key 635 635.54 0.00 0.00 200000 +
+select_key_prefix 639 638.34 0.00 0.00 200000 +
+select_many_fields 43 42.89 0.00 0.00 2000
+select_range 113 113.04 0.00 0.00 25420
+select_range_prefix 76 76.23 0.00 0.00 25010
+select_simple 13 13.45 0.00 0.00 10000
+select_simple_join 9 8.35 0.00 0.00 500
+update_big 96 96.78 0.00 0.00 500
+update_of_key 54 54.00 0.00 0.00 756
+update_of_key_big 40 39.93 0.00 0.00 501
+update_with_key 485 484.77 0.00 0.00 100000
+wisc_benchmark 18 18.67 0.00 0.00 114
+TOTALS 15551 15553.87 0.00 0.00 1540581 +++
diff --git a/sql-bench/Results-win32/RUN-mysql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/RUN-mysql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..4eea1681670 --- /dev/null +++ b/sql-bench/Results-win32/RUN-mysql_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: 1999-02-07 11:41:07 +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 + +alter-table: Total time: 4 secs ( 4.33 usr 0.00 sys = 4.33 cpu) +ATIS: Total time: 168 secs (167.31 usr 0.00 sys = 167.31 cpu) +big-tables: Total time: 100 secs (100.14 usr 0.00 sys = 100.14 cpu) +connect: Total time: 459 secs (458.81 usr 0.00 sys = 458.81 cpu) +create: Total time: 78 secs (78.59 usr 0.00 sys = 78.59 cpu) +insert: Total time: 6744 secs (6743.40 usr 0.00 sys = 6743.40 cpu) +select: Estimated total time: 1003 secs (1003.10 usr 0.00 sys = 1003.10 cpu) +wisconsin: Total time: 74 secs (74.07 usr 0.00 sys = 74.07 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.61 0.00 0.61 8 +connect 189 188.69 0.00 188.69 10000 +connect+select 211 211.59 0.00 211.59 10000 +count 58 58.27 0.00 58.27 100 +count_key 709 709.52 0.00 709.52 50000 + +count_on_key 34 33.86 0.00 33.86 100 +create+drop 15 15.21 0.00 15.21 1000 +create_index 1 0.91 0.00 0.91 8 +create_key+drop 20 20.05 0.00 20.05 1000 +create_table 23 22.06 0.00 22.06 1031 +delete_big 681 680.82 0.00 680.82 15 +delete_key 2 1.83 0.00 1.83 500 +drop_index 1 1.11 0.00 1.11 8 +drop_table 4 3.80 0.00 3.80 1028 +insert 619 619.49 0.00 619.49 350768 +insert_duplicates 144 143.90 0.00 143.90 300000 +insert_key 2908 2907.97 0.00 2907.97 100000 +insert_many_fields 40 40.29 0.00 40.29 20000 +min_max 28 28.04 0.00 28.04 60 +min_max_on_key 268 267.73 0.00 267.73 73000 +order_by 382 381.52 0.00 381.52 10 +order_by_key 355 355.39 0.00 355.39 10 +select 39 38.76 0.00 38.76 20000 +select_big 377 376.50 0.00 376.50 10080 +select_distinct 35 35.07 0.00 35.07 800 +select_group 61 61.91 0.00 61.91 3191 +select_join 91 90.99 0.00 90.99 200 +select_key 464 463.54 0.00 463.54 200000 +select_key_prefix 470 470.56 0.00 470.56 200000 +select_many_fields 60 59.85 0.00 59.85 20000 +select_range 62 61.89 0.00 61.89 25400 +select_range_prefix 51 50.65 0.00 50.65 25000 +select_simple_join 10 9.62 0.00 9.62 500 +update_key 1 0.95 0.00 0.95 500 +update_key_big 26 26.35 0.00 26.35 501 +update_of_key 164 163.52 0.00 163.52 256 +wisc_benchmark 23 23.44 0.00 23.44 114 +TOTALS 8627 8626.26 0.00 8626.26 1425188 + diff --git a/sql-bench/Results-win32/RUN-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/RUN-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..db88db47926 --- /dev/null +++ b/sql-bench/Results-win32/RUN-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,59 @@ +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 ++++++++
diff --git a/sql-bench/Results-win32/RUN-solid_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/RUN-solid_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..766942e7db3 --- /dev/null +++ b/sql-bench/Results-win32/RUN-solid_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-10-23 9:11:16 +Running tests on: Windows NT Version 4.0 +Arguments: --force +Comments: +Limits from: db2,informix,ms-sql,mysql,oracle,solid,sybase +Server version: Solid version ??? + +alter-table: Total time: 7 secs ( 6.71 usr 0.00 sys = 6.71 cpu) +ATIS: Estimated total time: 1248 secs (1248.81 usr 0.00 sys = 1248.81 cpu) +big-tables: Total time: 107 secs (107.11 usr 0.00 sys = 107.11 cpu) +connect: Total time: 871 secs (871.19 usr 0.00 sys = 871.19 cpu) +create: Total time: 161 secs (160.95 usr 0.00 sys = 160.95 cpu) +insert: Estimated total time: 192155 secs (192149.60 usr 0.00 sys = 192149.60 cpu) +select: Estimated total time: 28523 secs (28507.76 usr 0.00 sys = 28507.76 cpu) +wisconsin: Total time: 338 secs (338.33 usr 0.00 sys = 338.33 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.07 0.00 0.07 8 +connect 385 385.29 0.00 385.29 10000 +connect+select 414 413.81 0.00 413.81 10000 +count 2221 2220.87 0.00 2220.87 100 +count_key 16862 16847.20 0.00 16847.20 50000 + +count_on_key 2139 2139.16 0.00 2139.16 100 +create+drop 41 41.20 0.00 41.20 1000 +create_index 1 1.06 0.00 1.06 8 +create_key+drop 72 72.18 0.00 72.18 1000 +create_table 24 23.35 0.00 23.35 1031 +delete_big 2236 2235.76 0.00 2235.76 15 +delete_key 65 65.34 0.00 65.34 500 +drop_index 1 0.97 0.00 0.97 8 +drop_table 20 19.66 0.00 19.66 1028 +insert 1801 1801.89 0.00 1801.89 350768 +insert_duplicates 172 172.25 0.00 172.25 300000 +insert_key 9758 9757.93 0.00 9757.93 100000 +insert_many_fields 49 48.44 0.00 48.44 20000 +min_max 36388 36350.61 0.00 36350.61 3000 + +min_max_on_key 11504 11503.86 0.00 11503.86 73000 + +order_by 648 647.94 0.00 647.94 10 +order_by_key 653 653.06 0.00 653.06 10 +select 47 47.32 0.00 47.32 20000 +select_big 619 618.61 0.00 618.61 10080 +select_distinct 327 327.14 0.00 327.14 800 +select_group 2608 2608.20 0.00 2608.20 3191 +select_join 698 698.11 0.00 698.11 200 + +select_key 877 877.85 0.00 877.85 200000 + +select_key_prefix 843 842.99 0.00 842.99 200000 + +select_many_fields 56 56.39 0.00 56.39 20000 +select_range 22763 22774.06 0.00 22774.06 25400 ++ +select_range_prefix 22548 22532.98 0.00 22532.98 25000 ++ +select_simple_join 69 69.48 0.00 69.48 500 +update_key 2 2.71 0.00 2.71 500 +update_key_big 994 993.63 0.00 993.63 501 +update_of_key 16656 16655.63 0.00 16655.63 256 +wisc_benchmark 84 83.66 0.00 83.66 114 +TOTALS 154645 154590.66 0.00 154590.66 1428128 ++++++++++ diff --git a/sql-bench/Results-win32/RUN-sybase_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/RUN-sybase_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..4cf61ed860d --- /dev/null +++ b/sql-bench/Results-win32/RUN-sybase_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,58 @@ +Benchmark DBD suite: 2.0 +Date of test: 1998-10-02 8:13:24 +Running tests on: Windows NT Version 4.0 +Arguments: --force +Comments: +Limits from: db2,informix,ms-sql,mysql,oracle,solid,sybase +Server version: Sybase enterprise 11.5 NT + +ATIS: Total time: 338 secs (337.94 usr 0.00 sys = 337.94 cpu) +alter-table: Total time: 12 secs (12.39 usr 0.00 sys = 12.39 cpu) +big-tables: Total time: 353 secs (352.68 usr 0.00 sys = 352.68 cpu) +connect: Total time: 2725 secs (2724.61 usr 0.00 sys = 2724.61 cpu) +create: Total time: 228 secs (228.22 usr 0.00 sys = 228.22 cpu) +insert: Estimated total time: 69907 secs (69908.40 usr 0.00 sys = 69908.40 cpu) +select: Failed (results-win32/select-sybase_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase) +wisconsin: Failed (results-win32/wisconsin-sybase_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase) + +Of 8 tests, 2 tests didn't work +Tests with estimated time have a + at end of line + +Totals per operation: +Operation seconds usr sys cpu tests +alter_table_add 1 0.14 0.00 0.14 8 +connect 1275 1274.97 0.00 1274.97 10000 +connect+select 1330 1329.69 0.00 1329.69 10000 +count 23 22.40 0.00 22.40 100 +count_on_key 14 14.21 0.00 14.21 100 +create+drop 63 63.53 0.00 63.53 1000 +create_index 0 0.41 0.00 0.41 8 +create_key+drop 52 51.41 0.00 51.41 1000 +create_table 82 81.78 0.00 81.78 1028 +delete_big 7917 7916.71 0.00 7916.71 14 +delete_key 43 42.44 0.00 42.44 500 +drop_index 0 0.07 0.00 0.07 8 +drop_table 19 18.94 0.00 18.94 1028 +insert 4802 4801.96 0.00 4801.96 309768 +insert_duplicates 331 331.28 0.00 331.28 300000 +insert_key 7053 7053.03 0.00 7053.03 100000 +insert_many_fields 231 230.56 0.00 230.56 20000 +min_max 17 16.74 0.00 16.74 60 +min_max_on_key 96 96.64 0.00 96.64 3000 +order_by 395 394.89 0.00 394.89 10 +order_by_key 273 272.97 0.00 272.97 10 +select 80 79.97 0.00 79.97 20000 +select_big 315 314.76 0.00 314.76 10010 +select_distinct 64 63.34 0.00 63.34 800 +select_group 91 91.13 0.00 91.13 3191 +select_join 114 114.63 0.00 114.63 200 +select_key 17614 17614.13 0.00 17614.13 200000 + +select_key_prefix 17410 17410.02 0.00 17410.02 200000 + +select_many_fields 122 122.05 0.00 122.05 20000 +select_range 2626 2624.11 0.00 2624.11 25000 ++ +select_range_prefix 2618 2620.08 0.00 2620.08 25000 ++ +select_simple_join 17 16.86 0.00 16.86 500 +update_key 40 39.90 0.00 39.90 500 +update_key_big 347 347.05 0.00 347.05 501 +update_of_key 1023 1022.68 0.00 1022.68 256 +TOTALS 66498 66495.48 0.00 66495.48 1263600 ++++++ diff --git a/sql-bench/Results-win32/alter-table-access_odbc-win98-cmp-access,mysql b/sql-bench/Results-win32/alter-table-access_odbc-win98-cmp-access,mysql new file mode 100644 index 00000000000..e3aef89c461 --- /dev/null +++ b/sql-bench/Results-win32/alter-table-access_odbc-win98-cmp-access,mysql @@ -0,0 +1,16 @@ +Testing server 'Access 2000' at 2000-01-03 3:59:28
+
+Testing of ALTER TABLE
+Testing with 255 columns and 1000 rows in 20 steps
+Insert data into the table
+Time for insert (1000) 6 wallclock secs ( 5.93 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Time for alter_table_add (247): 1 wallclock secs ( 1.15 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Time for create_index (8): 0 wallclock secs ( 0.11 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Time for drop_index (8): 0 wallclock secs ( 0.06 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Time for alter_table_drop (124): 1 wallclock secs ( 0.71 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Total time: 8 wallclock secs ( 8.02 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/alter-table-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/alter-table-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..8ed8d259e13 --- /dev/null +++ b/sql-bench/Results-win32/alter-table-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,10 @@ +Testing server 'IBM DB2 5' at 1998-11-21 23:08:51 + +Testing of ALTER TABLE +Testing with 16 columns and 1000 rows in 20 steps +Insert data into the table +Time for insert (1000)10 secs (10.26 usr 0.00 sys = 10.26 cpu) + +Time for alter_table_add (8): 0 secs ( 0.20 usr 0.00 sys = 0.20 cpu) + +Time for create_index (8): 1 secs ( 0.91 usr 0.00 sys = 0.91 cpu) diff --git a/sql-bench/Results-win32/alter-table-informix_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/alter-table-informix_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..cad6c802af6 --- /dev/null +++ b/sql-bench/Results-win32/alter-table-informix_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,14 @@ +Testing server 'Informix 7.30C1 ' at 1998-09-01 2:00:29 + +Testing of ALTER TABLE +Testing with 16 columns and 1000 rows in 20 steps +Insert data into the table +Time for insert (1000) 6 secs ( 5.53 usr 0.00 sys = 5.53 cpu) + +Time for alter_table_add (8): 0 secs ( 0.39 usr 0.00 sys = 0.39 cpu) + +Time for create_index (8): 1 secs ( 0.44 usr 0.00 sys = 0.44 cpu) + +Time for drop_index (8): 0 secs ( 0.10 usr 0.00 sys = 0.10 cpu) + +Total time: 7 secs ( 6.60 usr 0.00 sys = 6.60 cpu) diff --git a/sql-bench/Results-win32/alter-table-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/alter-table-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..7c2495ffe54 --- /dev/null +++ b/sql-bench/Results-win32/alter-table-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,14 @@ +Testing server 'Microsoft SQL Server 7.00 - 7.00.517 (Intel X86) ' at 1998-09-07 2:15:14 + +Testing of ALTER TABLE +Testing with 16 columns and 1000 rows in 20 steps +Insert data into the table +Time for insert (1000) 6 secs ( 6.49 usr 0.00 sys = 6.49 cpu) + +Time for alter_table_add (8): 0 secs ( 0.04 usr 0.00 sys = 0.04 cpu) + +Time for create_index (8): 1 secs ( 0.64 usr 0.00 sys = 0.64 cpu) + +Time for drop_index (8): 0 secs ( 0.07 usr 0.00 sys = 0.07 cpu) + +Total time: 7 secs ( 7.50 usr 0.00 sys = 7.50 cpu) diff --git a/sql-bench/Results-win32/alter-table-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/alter-table-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..a3d6284dd67 --- /dev/null +++ b/sql-bench/Results-win32/alter-table-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,14 @@ +Testing server 'MySQL 3.22.16 gamma' at 1999-02-20 19:54:12 + +Testing of ALTER TABLE +Testing with 16 columns and 1000 rows in 20 steps +Insert data into the table +Time for insert (1000) 1 wallclock secs ( 0.18 usr + 0.17 sys = 0.35 CPU) + +Time for alter_table_add (8): 1 wallclock secs ( 0.01 usr + 0.00 sys = 0.01 CPU) + +Time for create_index (8): 2 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) + +Time for drop_index (8): 1 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) + +Total time: 5 wallclock secs ( 0.19 usr + 0.17 sys = 0.36 CPU) diff --git a/sql-bench/Results-win32/alter-table-mysql-win98 b/sql-bench/Results-win32/alter-table-mysql-win98 new file mode 100644 index 00000000000..922aa8906a9 --- /dev/null +++ b/sql-bench/Results-win32/alter-table-mysql-win98 @@ -0,0 +1,16 @@ +Testing server 'MySQL 3.23.13a alpha' at 2000-03-15 1:51:14
+
+Testing of ALTER TABLE
+Testing with 1000 columns and 1000 rows in 20 steps
+Insert data into the table
+Time for insert (1000) 1 wallclock secs ( 1.09 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Time for alter_table_add (992): 1046 wallclock secs (1046.38 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Time for create_index (8): 17 wallclock secs (16.70 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Time for drop_index (8): 17 wallclock secs (16.64 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Time for alter_table_drop (496): 773 wallclock secs (772.97 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Total time: 1855 wallclock secs (1854.89 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/alter-table-mysql-win98-cmp-access,mysql b/sql-bench/Results-win32/alter-table-mysql-win98-cmp-access,mysql new file mode 100644 index 00000000000..fcb94e46b89 --- /dev/null +++ b/sql-bench/Results-win32/alter-table-mysql-win98-cmp-access,mysql @@ -0,0 +1,16 @@ +Testing server 'MySQL 3.23.8 alpha' at 2000-01-04 20:05:06
+
+Testing of ALTER TABLE
+Testing with 255 columns and 1000 rows in 20 steps
+Insert data into the table
+Time for insert (1000) 1 wallclock secs ( 1.21 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Time for alter_table_add (247): 31 wallclock secs (30.48 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Time for create_index (8): 2 wallclock secs ( 2.09 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Time for drop_index (8): 2 wallclock secs ( 1.98 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Time for alter_table_drop (124): 21 wallclock secs (21.25 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Total time: 57 wallclock secs (57.17 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/alter-table-mysql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/alter-table-mysql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..f05586245dd --- /dev/null +++ b/sql-bench/Results-win32/alter-table-mysql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,14 @@ +Testing server 'MySQL 3.22.16 gamma' at 1999-02-07 11:41:08 + +Testing of ALTER TABLE +Testing with 16 columns and 1000 rows in 20 steps +Insert data into the table +Time for insert (1000) 1 secs ( 1.66 usr 0.00 sys = 1.66 cpu) + +Time for alter_table_add (8): 1 secs ( 0.61 usr 0.00 sys = 0.61 cpu) + +Time for create_index (8): 1 secs ( 0.91 usr 0.00 sys = 0.91 cpu) + +Time for drop_index (8): 1 secs ( 1.11 usr 0.00 sys = 1.11 cpu) + +Total time: 4 secs ( 4.33 usr 0.00 sys = 4.33 cpu) diff --git a/sql-bench/Results-win32/alter-table-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/alter-table-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..216c20f0245 --- /dev/null +++ b/sql-bench/Results-win32/alter-table-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,14 @@ +Testing server 'Oracle 8.0.4.0.0' at 1999-04-03 22:38:03
+
+Testing of ALTER TABLE
+Testing with 16 columns and 1000 rows in 20 steps
+Insert data into the table
+Time for insert (1000) 6 wallclock secs ( 1.14 usr 0.08 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Time for alter_table_add (8): 1 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Time for create_index (8): 0 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Time for drop_index (8): 1 wallclock secs ( 0.01 usr 0.02 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Total time: 8 wallclock secs ( 1.15 usr 0.10 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/alter-table-solid_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/alter-table-solid_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..4058a2aa8cf --- /dev/null +++ b/sql-bench/Results-win32/alter-table-solid_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,14 @@ +Testing server 'Solid version ???' at 1998-10-06 17:43:33 + +Testing of ALTER TABLE +Testing with 16 columns and 1000 rows in 20 steps +Insert data into the table +Time for insert (1000) 5 secs ( 4.42 usr 0.00 sys = 4.42 cpu) + +Time for alter_table_add (8): 0 secs ( 0.07 usr 0.00 sys = 0.07 cpu) + +Time for create_index (8): 1 secs ( 1.06 usr 0.00 sys = 1.06 cpu) + +Time for drop_index (8): 1 secs ( 0.97 usr 0.00 sys = 0.97 cpu) + +Total time: 7 secs ( 6.71 usr 0.00 sys = 6.71 cpu) diff --git a/sql-bench/Results-win32/alter-table-sybase_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/alter-table-sybase_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..98d44441908 --- /dev/null +++ b/sql-bench/Results-win32/alter-table-sybase_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,14 @@ +Testing server 'Sybase enterprise 11.5 NT' at 1998-08-27 2:08:17 + +Testing of ALTER TABLE +Testing with 16 columns and 1000 rows in 20 steps +Insert data into the table +Time for insert (1000)11 secs (11.30 usr 0.00 sys = 11.30 cpu) + +Time for alter_table_add (8): 1 secs ( 0.14 usr 0.00 sys = 0.14 cpu) + +Time for create_index (8): 0 secs ( 0.41 usr 0.00 sys = 0.41 cpu) + +Time for drop_index (8): 0 secs ( 0.07 usr 0.00 sys = 0.07 cpu) + +Total time: 12 secs (12.39 usr 0.00 sys = 12.39 cpu) diff --git a/sql-bench/Results-win32/big-tables-access_odbc-win98-cmp-access,mysql b/sql-bench/Results-win32/big-tables-access_odbc-win98-cmp-access,mysql new file mode 100644 index 00000000000..a37d1050f43 --- /dev/null +++ b/sql-bench/Results-win32/big-tables-access_odbc-win98-cmp-access,mysql @@ -0,0 +1,19 @@ +Testing server 'Access 2000' at 2000-01-03 4:03:38
+
+Testing of some unusual tables
+All tests are done 1000 times with 255 fields
+
+Testing table with 255 fields
+Testing select * from table with 1 record
+Time to select_many_fields(1000): 126 wallclock secs (125.72 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing select all_fields from table with 1 record
+Time to select_many_fields(1000): 194 wallclock secs (194.17 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing insert VALUES()
+Time to insert_many_fields(1000): 42 wallclock secs (42.34 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing insert (all_fields) VALUES()
+Time to insert_many_fields(1000): 82 wallclock secs (82.17 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Total time: 457 wallclock secs (457.69 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/big-tables-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/big-tables-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..82183d9221d --- /dev/null +++ b/sql-bench/Results-win32/big-tables-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,19 @@ +Testing server 'IBM DB2 5' at 1998-11-21 23:18:02 + +Testing of some unusual tables +All tests are done 10000 times with 16 fields + +Testing table with 16 fields +Testing select * from table with 1 record +Time to select_many_fields(10000): 56 secs (56.08 usr 0.00 sys = 56.08 cpu) + +Testing select all_fields from table with 1 record +Time to select_many_fields(10000): 57 secs (56.82 usr 0.00 sys = 56.82 cpu) + +Testing insert VALUES() +Time to insert_many_fields(10000): 67 secs (67.80 usr 0.00 sys = 67.80 cpu) + +Testing insert (all_fields) VALUES() +Time to insert_many_fields(10000): 68 secs (67.82 usr 0.00 sys = 67.82 cpu) + +Total time: 250 secs (249.43 usr 0.00 sys = 249.43 cpu) diff --git a/sql-bench/Results-win32/big-tables-informix_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/big-tables-informix_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..5bfdaf2ad6f --- /dev/null +++ b/sql-bench/Results-win32/big-tables-informix_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,19 @@ +Testing server 'Informix 7.30C1 ' at 1998-09-01 2:06:11 + +Testing of some unusual tables +All tests are done 10000 times with 16 fields + +Testing table with 16 fields +Testing select * from table with 1 record +Time to select_many_fields(10000): 83 secs (83.28 usr 0.00 sys = 83.28 cpu) + +Testing select all_fields from table with 1 record +Time to select_many_fields(10000): 91 secs (91.36 usr 0.00 sys = 91.36 cpu) + +Testing insert VALUES() +Time to insert_many_fields(10000): 54 secs (53.26 usr 0.00 sys = 53.26 cpu) + +Testing insert (all_fields) VALUES() +Time to insert_many_fields(10000): 57 secs (57.68 usr 0.00 sys = 57.68 cpu) + +Total time: 285 secs (285.73 usr 0.00 sys = 285.73 cpu) diff --git a/sql-bench/Results-win32/big-tables-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/big-tables-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..4089de66c75 --- /dev/null +++ b/sql-bench/Results-win32/big-tables-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,19 @@ +Testing server 'Microsoft SQL Server 7.00 - 7.00.517 (Intel X86) ' at 1998-09-07 2:19:13 + +Testing of some unusual tables +All tests are done 10000 times with 16 fields + +Testing table with 16 fields +Testing select * from table with 1 record +Time to select_many_fields(10000): 39 secs (39.20 usr 0.00 sys = 39.20 cpu) + +Testing select all_fields from table with 1 record +Time to select_many_fields(10000): 39 secs (39.41 usr 0.00 sys = 39.41 cpu) + +Testing insert VALUES() +Time to insert_many_fields(10000): 39 secs (38.70 usr 0.00 sys = 38.70 cpu) + +Testing insert (all_fields) VALUES() +Time to insert_many_fields(10000): 37 secs (37.06 usr 0.00 sys = 37.06 cpu) + +Total time: 155 secs (154.44 usr 0.00 sys = 154.44 cpu) diff --git a/sql-bench/Results-win32/big-tables-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/big-tables-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..ee1bad8c086 --- /dev/null +++ b/sql-bench/Results-win32/big-tables-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,19 @@ +Testing server 'MySQL 3.22.16 gamma' at 1999-02-20 19:54:17 + +Testing of some unusual tables +All tests are done 10000 times with 16 fields + +Testing table with 16 fields +Testing select * from table with 1 record +Time to select_many_fields(10000): 17 wallclock secs ( 8.14 usr + 2.49 sys = 10.64 CPU) + +Testing select all_fields from table with 1 record +Time to select_many_fields(10000): 27 wallclock secs ( 7.93 usr + 2.70 sys = 10.64 CPU) + +Testing insert VALUES() +Time to insert_many_fields(10000): 13 wallclock secs ( 6.14 usr + 1.46 sys = 7.60 CPU) + +Testing insert (all_fields) VALUES() +Time to insert_many_fields(10000): 17 wallclock secs ( 1.18 usr + 1.38 sys = 2.56 CPU) + +Total time: 74 wallclock secs (23.40 usr + 8.04 sys = 31.45 CPU) diff --git a/sql-bench/Results-win32/big-tables-mysql-win98 b/sql-bench/Results-win32/big-tables-mysql-win98 new file mode 100644 index 00000000000..dc57828441f --- /dev/null +++ b/sql-bench/Results-win32/big-tables-mysql-win98 @@ -0,0 +1,19 @@ +Testing server 'MySQL 3.23.13a alpha' at 2000-03-15 2:24:33
+
+Testing of some unusual tables
+All tests are done 1000 times with 1000 fields
+
+Testing table with 1000 fields
+Testing select * from table with 1 record
+Time to select_many_fields(1000): 55 wallclock secs (55.36 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing select all_fields from table with 1 record
+Time to select_many_fields(1000): 69 wallclock secs (68.88 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing insert VALUES()
+Time to insert_many_fields(1000): 6 wallclock secs ( 6.20 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing insert (all_fields) VALUES()
+Time to insert_many_fields(1000): 19 wallclock secs (18.51 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Total time: 151 wallclock secs (150.66 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/big-tables-mysql-win98-cmp-access,mysql b/sql-bench/Results-win32/big-tables-mysql-win98-cmp-access,mysql new file mode 100644 index 00000000000..0eac237d1bc --- /dev/null +++ b/sql-bench/Results-win32/big-tables-mysql-win98-cmp-access,mysql @@ -0,0 +1,19 @@ +Testing server 'MySQL 3.23.8 alpha' at 2000-01-04 12:20:10
+
+Testing of some unusual tables
+All tests are done 1000 times with 255 fields
+
+Testing table with 255 fields
+Testing select * from table with 1 record
+Time to select_many_fields(1000): 20 wallclock secs (19.77 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing select all_fields from table with 1 record
+Time to select_many_fields(1000): 23 wallclock secs (23.12 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing insert VALUES()
+Time to insert_many_fields(1000): 3 wallclock secs ( 2.86 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing insert (all_fields) VALUES()
+Time to insert_many_fields(1000): 5 wallclock secs ( 5.05 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Total time: 51 wallclock secs (50.91 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/big-tables-mysql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/big-tables-mysql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..140650bba24 --- /dev/null +++ b/sql-bench/Results-win32/big-tables-mysql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,19 @@ +Testing server 'MySQL 3.22.16 gamma' at 1999-02-07 11:44:00 + +Testing of some unusual tables +All tests are done 10000 times with 16 fields + +Testing table with 16 fields +Testing select * from table with 1 record +Time to select_many_fields(10000): 25 secs (24.41 usr 0.00 sys = 24.41 cpu) + +Testing select all_fields from table with 1 record +Time to select_many_fields(10000): 35 secs (35.44 usr 0.00 sys = 35.44 cpu) + +Testing insert VALUES() +Time to insert_many_fields(10000): 15 secs (15.06 usr 0.00 sys = 15.06 cpu) + +Testing insert (all_fields) VALUES() +Time to insert_many_fields(10000): 25 secs (25.23 usr 0.00 sys = 25.23 cpu) + +Total time: 100 secs (100.14 usr 0.00 sys = 100.14 cpu) diff --git a/sql-bench/Results-win32/big-tables-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/big-tables-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..d7c7f5f846f --- /dev/null +++ b/sql-bench/Results-win32/big-tables-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,19 @@ +Testing server 'Oracle 8.0.4.0.0' at 1999-04-03 22:38:13
+
+Testing of some unusual tables
+All tests are done 10000 times with 16 fields
+
+Testing table with 16 fields
+Testing select * from table with 1 record
+Time to select_many_fields(10000): 48 wallclock secs (31.69 usr 4.93 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing select all_fields from table with 1 record
+Time to select_many_fields(10000): 48 wallclock secs (32.70 usr 5.03 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing insert VALUES()
+Time to insert_many_fields(10000): 69 wallclock secs (14.82 usr 1.82 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing insert (all_fields) VALUES()
+Time to insert_many_fields(10000): 81 wallclock secs (14.73 usr 1.51 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Total time: 246 wallclock secs (93.94 usr 13.29 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/big-tables-solid_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/big-tables-solid_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..3ac6358776a --- /dev/null +++ b/sql-bench/Results-win32/big-tables-solid_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,19 @@ +Testing server 'Solid version ???' at 1998-10-06 18:02:53 + +Testing of some unusual tables +All tests are done 10000 times with 16 fields + +Testing table with 16 fields +Testing select * from table with 1 record +Time to select_many_fields(10000): 30 secs (29.42 usr 0.00 sys = 29.42 cpu) + +Testing select all_fields from table with 1 record +Time to select_many_fields(10000): 26 secs (26.97 usr 0.00 sys = 26.97 cpu) + +Testing insert VALUES() +Time to insert_many_fields(10000): 25 secs (24.27 usr 0.00 sys = 24.27 cpu) + +Testing insert (all_fields) VALUES() +Time to insert_many_fields(10000): 24 secs (24.17 usr 0.00 sys = 24.17 cpu) + +Total time: 107 secs (107.11 usr 0.00 sys = 107.11 cpu) diff --git a/sql-bench/Results-win32/big-tables-sybase_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/big-tables-sybase_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..b25986c12fb --- /dev/null +++ b/sql-bench/Results-win32/big-tables-sybase_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,19 @@ +Testing server 'Sybase enterprise 11.5 NT' at 1998-08-27 2:14:09 + +Testing of some unusual tables +All tests are done 10000 times with 16 fields + +Testing table with 16 fields +Testing select * from table with 1 record +Time to select_many_fields(10000): 54 secs (54.47 usr 0.00 sys = 54.47 cpu) + +Testing select all_fields from table with 1 record +Time to select_many_fields(10000): 68 secs (67.58 usr 0.00 sys = 67.58 cpu) + +Testing insert VALUES() +Time to insert_many_fields(10000): 115 secs (115.28 usr 0.00 sys = 115.28 cpu) + +Testing insert (all_fields) VALUES() +Time to insert_many_fields(10000): 116 secs (115.28 usr 0.00 sys = 115.28 cpu) + +Total time: 353 secs (352.68 usr 0.00 sys = 352.68 cpu) diff --git a/sql-bench/Results-win32/connect-access_odbc-win98-cmp-access,mysql b/sql-bench/Results-win32/connect-access_odbc-win98-cmp-access,mysql new file mode 100644 index 00000000000..f79ffcb44ee --- /dev/null +++ b/sql-bench/Results-win32/connect-access_odbc-win98-cmp-access,mysql @@ -0,0 +1,33 @@ +Testing server 'Access 2000' at 2000-01-04 1:49:15
+
+Testing the speed of connecting to the server and sending of data
+All tests are done 10000 times
+
+Testing connection/disconnect
+Time to connect (10000): 1267 wallclock secs (1267.63 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Test connect/simple select/disconnect
+Time for connect+select_simple (10000): 1766 wallclock secs (1765.08 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Test simple select
+Time for select_simple (10000): 38 wallclock secs (38.12 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing connect/select 1 row from table/disconnect
+DBI->connect failed: [Microsoft][Drivrutin för ODBC Microsoft Access] Fel på disk eller nätverk. (SQL-S1000)(DBD: db_login/SQLConnect err=-1) at test-connect line 140
+Warning: 1 connections didn't work without a time delay
+Time to connect+select_1_row (10000): 1780 wallclock secs (1779.92 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing select 1 row from table
+Time to select_1_row (10000): 55 wallclock secs (55.04 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing select 2 rows from table
+Time to select_2_rows (10000): 56 wallclock secs (55.81 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing retrieval of big records (255 bytes)
+Time to select_big (10000): 50 wallclock secs (49.92 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+[Microsoft][Drivrutin för ODBC Microsoft Access] Databasmotorn kunde inte låsa tabellen 'bench1'. Den används redan av en annan användare eller process. (SQL-S1000)(DBD: st_execute/SQLExecute err=-1) at test-connect line 240.
+
+# The following row is calculated by hand from the above:
+
+Total time: 5012 wallclock secs (5011.52 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
\ No newline at end of file diff --git a/sql-bench/Results-win32/connect-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/connect-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..a6fbfc1695e --- /dev/null +++ b/sql-bench/Results-win32/connect-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,6 @@ +Testing server 'IBM DB2 5' at 1999-02-02 7:07:03 + +Testing the speed of connecting to the server and sending of data +All tests are done 10000 times + +Testing connection/disconnect diff --git a/sql-bench/Results-win32/connect-informix_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/connect-informix_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..0619aa5eb7d --- /dev/null +++ b/sql-bench/Results-win32/connect-informix_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,21 @@ +Testing server 'Informix 7.30C1 ' at 1998-09-01 2:10:58 + +Testing the speed of connecting to the server and sending of data +All tests are done 10000 times + +Testing connection/disconnect +Time to connect (10000): 1989 secs (1989.51 usr 0.00 sys = 1989.51 cpu) + +Testing connect/select 1 row from table/disconnect +Time to connect+select (10000): 2050 secs (2049.47 usr 0.00 sys = 2049.47 cpu) + +Testing select 1 row from table +Time to select (10000): 56 secs (55.99 usr 0.00 sys = 55.99 cpu) + +Testing select 2 rows from table +Time to select (10000): 56 secs (56.37 usr 0.00 sys = 56.37 cpu) + +Testing retrieval of big records (224 bytes) +Time to select_big (10000): 73 secs (73.49 usr 0.00 sys = 73.49 cpu) + +Total time: 4225 secs (4225.65 usr 0.00 sys = 4225.65 cpu) diff --git a/sql-bench/Results-win32/connect-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/connect-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..fb72abf899c --- /dev/null +++ b/sql-bench/Results-win32/connect-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,21 @@ +Testing server 'Microsoft SQL Server 7.00 - 7.00.517 (Intel X86) ' at 1998-09-07 2:21:49 + +Testing the speed of connecting to the server and sending of data +All tests are done 10000 times + +Testing connection/disconnect +Time to connect (10000): 202 secs (201.91 usr 0.00 sys = 201.91 cpu) + +Testing connect/select 1 row from table/disconnect +Time to connect+select (10000): 234 secs (234.54 usr 0.00 sys = 234.54 cpu) + +Testing select 1 row from table +Time to select (10000): 33 secs (32.33 usr 0.00 sys = 32.33 cpu) + +Testing select 2 rows from table +Time to select (10000): 32 secs (32.45 usr 0.00 sys = 32.45 cpu) + +Testing retrieval of big records (224 bytes) +Time to select_big (10000): 34 secs (33.44 usr 0.00 sys = 33.44 cpu) + +Total time: 535 secs (534.85 usr 0.00 sys = 534.85 cpu) diff --git a/sql-bench/Results-win32/connect-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/connect-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..315b8c78a73 --- /dev/null +++ b/sql-bench/Results-win32/connect-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,21 @@ +Testing server 'MySQL 3.22.16 gamma' at 1999-02-20 19:55:31 + +Testing the speed of connecting to the server and sending of data +All tests are done 10000 times + +Testing connection/disconnect +Time to connect (10000): 56 wallclock secs (16.91 usr + 13.01 sys = 29.92 CPU) + +Testing connect/select 1 row from table/disconnect +Time to connect+select (10000): 64 wallclock secs (18.76 usr + 14.96 sys = 33.72 CPU) + +Testing select 1 row from table +Time to select (10000): 9 wallclock secs ( 1.66 usr + 1.76 sys = 3.43 CPU) + +Testing select 2 rows from table +Time to select (10000): 12 wallclock secs ( 1.84 usr + 2.02 sys = 3.87 CPU) + +Testing retrieval of big records (224 bytes) +Time to select_big (10000): 14 wallclock secs ( 6.55 usr + 1.80 sys = 8.35 CPU) + +Total time: 155 wallclock secs (45.74 usr + 33.56 sys = 79.29 CPU) diff --git a/sql-bench/Results-win32/connect-mysql-win98 b/sql-bench/Results-win32/connect-mysql-win98 new file mode 100644 index 00000000000..cf0c35ddc8e --- /dev/null +++ b/sql-bench/Results-win32/connect-mysql-win98 @@ -0,0 +1,27 @@ +Testing server 'MySQL 3.23.13a alpha' at 2000-03-15 2:27:04
+
+Testing the speed of connecting to the server and sending of data
+All tests are done 10000 times
+
+Testing connection/disconnect
+Time to connect (10000): 52 wallclock secs (51.85 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Test connect/simple select/disconnect
+Time for connect+select_simple (10000): 67 wallclock secs (66.90 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Test simple select
+Time for select_simple (10000): 12 wallclock secs (12.20 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing connect/select 1 row from table/disconnect
+Time to connect+select_1_row (10000): 72 wallclock secs (71.95 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing select 1 row from table
+Time to select_1_row (10000): 16 wallclock secs (15.99 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing select 2 rows from table
+Time to select_2_rows (10000): 19 wallclock secs (18.89 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing retrieval of big records (65000 bytes)
+Time to select_big (10000): 130 wallclock secs (130.56 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Total time: 369 wallclock secs (368.94 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/connect-mysql-win98-cmp-access,mysql b/sql-bench/Results-win32/connect-mysql-win98-cmp-access,mysql new file mode 100644 index 00000000000..dd5a7eaac9d --- /dev/null +++ b/sql-bench/Results-win32/connect-mysql-win98-cmp-access,mysql @@ -0,0 +1,27 @@ +Testing server 'MySQL 3.23.8 alpha' at 2000-01-04 21:06:49
+
+Testing the speed of connecting to the server and sending of data
+All tests are done 10000 times
+
+Testing connection/disconnect
+Time to connect (10000): 55 wallclock secs (54.76 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Test connect/simple select/disconnect
+Time for connect+select_simple (10000): 71 wallclock secs (70.80 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Test simple select
+Time for select_simple (10000): 13 wallclock secs (13.45 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing connect/select 1 row from table/disconnect
+Time to connect+select_1_row (10000): 75 wallclock secs (75.96 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing select 1 row from table
+Time to select_1_row (10000): 18 wallclock secs (17.30 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing select 2 rows from table
+Time to select_2_rows (10000): 20 wallclock secs (20.65 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing retrieval of big records (255 bytes)
+Time to select_big (10000): 22 wallclock secs (22.19 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Total time: 276 wallclock secs (275.78 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/connect-mysql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/connect-mysql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..ff5511fa1a8 --- /dev/null +++ b/sql-bench/Results-win32/connect-mysql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,21 @@ +Testing server 'MySQL 3.22.16 gamma' at 1999-02-07 11:45:41 + +Testing the speed of connecting to the server and sending of data +All tests are done 10000 times + +Testing connection/disconnect +Time to connect (10000): 189 secs (188.69 usr 0.00 sys = 188.69 cpu) + +Testing connect/select 1 row from table/disconnect +Time to connect+select (10000): 211 secs (211.59 usr 0.00 sys = 211.59 cpu) + +Testing select 1 row from table +Time to select (10000): 19 secs (18.79 usr 0.00 sys = 18.79 cpu) + +Testing select 2 rows from table +Time to select (10000): 20 secs (19.97 usr 0.00 sys = 19.97 cpu) + +Testing retrieval of big records (224 bytes) +Time to select_big (10000): 20 secs (19.71 usr 0.00 sys = 19.71 cpu) + +Total time: 459 secs (458.81 usr 0.00 sys = 458.81 cpu) diff --git a/sql-bench/Results-win32/connect-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/connect-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..5420cdb3998 --- /dev/null +++ b/sql-bench/Results-win32/connect-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,21 @@ +Testing server 'Oracle 8.0.4.0.0' at 1999-04-03 22:42:21
+
+Testing the speed of connecting to the server and sending of data
+All tests are done 10000 times
+
+Testing connection/disconnect
+Time to connect (10000): 8713 wallclock secs (195.47 usr 436.40 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing connect/select 1 row from table/disconnect
+Time to connect+select (10000): 8722 wallclock secs (257.48 usr 362.71 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing select 1 row from table
+Time to select (10000): 24 wallclock secs (14.99 usr 1.74 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing select 2 rows from table
+Time to select (10000): 23 wallclock secs (15.59 usr 1.17 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing retrieval of big records (224 bytes)
+Time to select_big (10000): 35 wallclock secs (21.24 usr 4.63 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Total time: 17520 wallclock secs (504.84 usr 806.71 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/connect-solid_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/connect-solid_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..d42946a3995 --- /dev/null +++ b/sql-bench/Results-win32/connect-solid_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,21 @@ +Testing server 'Solid version ???' at 1998-10-06 18:04:41 + +Testing the speed of connecting to the server and sending of data +All tests are done 10000 times + +Testing connection/disconnect +Time to connect (10000): 385 secs (385.29 usr 0.00 sys = 385.29 cpu) + +Testing connect/select 1 row from table/disconnect +Time to connect+select (10000): 414 secs (413.81 usr 0.00 sys = 413.81 cpu) + +Testing select 1 row from table +Time to select (10000): 23 secs (23.32 usr 0.00 sys = 23.32 cpu) + +Testing select 2 rows from table +Time to select (10000): 24 secs (24.00 usr 0.00 sys = 24.00 cpu) + +Testing retrieval of big records (224 bytes) +Time to select_big (10000): 25 secs (24.64 usr 0.00 sys = 24.64 cpu) + +Total time: 871 secs (871.19 usr 0.00 sys = 871.19 cpu) diff --git a/sql-bench/Results-win32/connect-sybase_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/connect-sybase_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..b90e8036719 --- /dev/null +++ b/sql-bench/Results-win32/connect-sybase_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,21 @@ +Testing server 'Sybase enterprise 11.5 NT' at 1998-08-27 2:20:02 + +Testing the speed of connecting to the server and sending of data +All tests are done 10000 times + +Testing connection/disconnect +Time to connect (10000): 1275 secs (1274.97 usr 0.00 sys = 1274.97 cpu) + +Testing connect/select 1 row from table/disconnect +Time to connect+select (10000): 1330 secs (1329.69 usr 0.00 sys = 1329.69 cpu) + +Testing select 1 row from table +Time to select (10000): 40 secs (39.77 usr 0.00 sys = 39.77 cpu) + +Testing select 2 rows from table +Time to select (10000): 40 secs (40.20 usr 0.00 sys = 40.20 cpu) + +Testing retrieval of big records (224 bytes) +Time to select_big (10000): 40 secs (39.56 usr 0.00 sys = 39.56 cpu) + +Total time: 2725 secs (2724.61 usr 0.00 sys = 2724.61 cpu) diff --git a/sql-bench/Results-win32/create-access_odbc-win98-cmp-access,mysql b/sql-bench/Results-win32/create-access_odbc-win98-cmp-access,mysql new file mode 100644 index 00000000000..2feabb9ddf3 --- /dev/null +++ b/sql-bench/Results-win32/create-access_odbc-win98-cmp-access,mysql @@ -0,0 +1,18 @@ +Testing server 'Access 2000' at 2000-01-06 1:49:25
+
+Testing the speed of creating and droping tables
+All tests are done 7000 times
+
+Testing create of tables
+Time for create_many_tables (7000): 142 wallclock secs (141.43 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Accessing tables
+Time to select_group (7000): 52 wallclock secs (52.84 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing drop
+Time for drop_table (7000): 109 wallclock secs (109.63 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing create+drop
+Time for create+drop (7000): 187 wallclock secs (186.36 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for create_key+drop (7000): 207 wallclock secs (207.73 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Total time: 699 wallclock secs (698.76 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/create-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/create-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..1ae88e6607b --- /dev/null +++ b/sql-bench/Results-win32/create-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,20 @@ +Testing server 'IBM DB2 5' at 1999-02-02 7:10:24 + +Testing the speed of creating and droping tables +All tests are done 1000 times + +Okay..Let's make sure that our tables don't exist yet. + +Testing create of tables +Time for create_table (1000): 389 secs (389.60 usr 0.00 sys = 389.60 cpu) + +Accessing tables +Time to select_group (1000): 7 secs ( 7.37 usr 0.00 sys = 7.37 cpu) + +Testing drop +Time for drop_table (1000): 106 secs (106.19 usr 0.00 sys = 106.19 cpu) + +Testing create+drop +Time for create+drop (1000): 408 secs (408.21 usr 0.00 sys = 408.21 cpu) +Time for create_key+drop (1000): 193 secs (192.75 usr 0.00 sys = 192.75 cpu) +Total time: 1106 secs (1106.62 usr 0.00 sys = 1106.62 cpu) diff --git a/sql-bench/Results-win32/create-informix_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/create-informix_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..89ec2fcbfe4 --- /dev/null +++ b/sql-bench/Results-win32/create-informix_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,20 @@ +Testing server 'Informix 7.30C1 ' at 1998-09-01 3:21:25 + +Testing the speed of creating and droping tables +All tests are done 1000 times + +Okay..Let's make sure that our tables don't exist yet. + +Testing create of tables +Time for create_table (1000): 56 secs (55.74 usr 0.00 sys = 55.74 cpu) + +Accessing tables +Time to select_group (1000): 8 secs ( 8.49 usr 0.00 sys = 8.49 cpu) + +Testing drop +Time for drop_table (1000): 33 secs (32.69 usr 0.00 sys = 32.69 cpu) + +Testing create+drop +Time for create+drop (1000): 35 secs (35.34 usr 0.00 sys = 35.34 cpu) +Time for create_key+drop (1000): 90 secs (89.37 usr 0.00 sys = 89.37 cpu) +Total time: 222 secs (221.64 usr 0.00 sys = 221.64 cpu) diff --git a/sql-bench/Results-win32/create-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/create-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..e255cfc05a2 --- /dev/null +++ b/sql-bench/Results-win32/create-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,20 @@ +Testing server 'Microsoft SQL Server 7.00 - 7.00.517 (Intel X86) ' at 1998-09-07 10:22:16 + +Testing the speed of creating and droping tables +All tests are done 1000 times + +Okay..Let's make sure that our tables don't exist yet. + +Testing create of tables +Time for create_table (1000): 55 secs (55.35 usr 0.00 sys = 55.35 cpu) + +Accessing tables +Time to select_group (1000): 20 secs (20.25 usr 0.00 sys = 20.25 cpu) + +Testing drop +Time for drop_table (1000): 6 secs ( 5.80 usr 0.00 sys = 5.80 cpu) + +Testing create+drop +Time for create+drop (1000): 35 secs (34.23 usr 0.00 sys = 34.23 cpu) +Time for create_key+drop (1000): 36 secs (36.10 usr 0.00 sys = 36.10 cpu) +Total time: 152 secs (151.76 usr 0.00 sys = 151.76 cpu) diff --git a/sql-bench/Results-win32/create-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/create-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..822a7d6cda7 --- /dev/null +++ b/sql-bench/Results-win32/create-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,20 @@ +Testing server 'MySQL 3.22.16 gamma' at 1999-02-20 19:58:06 + +Testing the speed of creating and droping tables +All tests are done 1000 times + +Okay..Let's make sure that our tables don't exist yet. + +Testing create of tables +Time for create_table (1000): 23 wallclock secs ( 0.47 usr + 0.18 sys = 0.65 CPU) + +Accessing tables +Time to select_group (1000): 14 wallclock secs ( 0.22 usr + 0.11 sys = 0.33 CPU) + +Testing drop +Time for drop_table (1000): 3 wallclock secs ( 0.10 usr + 0.16 sys = 0.26 CPU) + +Testing create+drop +Time for create+drop (1000): 14 wallclock secs ( 0.40 usr + 0.19 sys = 0.59 CPU) +Time for create_key+drop (1000): 18 wallclock secs ( 0.85 usr + 0.33 sys = 1.18 CPU) +Total time: 72 wallclock secs ( 2.05 usr + 0.97 sys = 3.02 CPU) diff --git a/sql-bench/Results-win32/create-mysql-win98 b/sql-bench/Results-win32/create-mysql-win98 new file mode 100644 index 00000000000..e0211664f23 --- /dev/null +++ b/sql-bench/Results-win32/create-mysql-win98 @@ -0,0 +1,18 @@ +Testing server 'MySQL 3.23.13a alpha' at 2000-03-15 2:33:13
+
+Testing the speed of creating and droping tables
+Testing with 5000 tables and 10000 loop count
+
+Testing create of tables
+Time for create_MANY_tables (5000): 1510 wallclock secs (1510.83 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Accessing tables
+Time to select_group_when_MANY_tables (5000): 581 wallclock secs (580.46 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing drop
+Time for drop_table_when_MANY_tables (5000): 160 wallclock secs (159.83 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing create+drop
+Time for create+drop (10000): 1433 wallclock secs (1433.28 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for create_key+drop (10000): 1457 wallclock secs (1456.57 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Total time: 5141 wallclock secs (5140.97 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/create-mysql-win98-cmp-access,mysql b/sql-bench/Results-win32/create-mysql-win98-cmp-access,mysql new file mode 100644 index 00000000000..15de75eb663 --- /dev/null +++ b/sql-bench/Results-win32/create-mysql-win98-cmp-access,mysql @@ -0,0 +1,18 @@ +Testing server 'MySQL 3.23.8 alpha' at 2000-01-05 4:37:04
+
+Testing the speed of creating and droping tables
+All tests are done 7000 times
+
+Testing create of tables
+Time for create_many_tables (7000): 2530 wallclock secs (2529.76 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Accessing tables
+Time to select_group (7000): 4718 wallclock secs (4718.04 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing drop
+Time for drop_table (7000): 316 wallclock secs (315.66 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing create+drop
+Time for create+drop (7000): 1011 wallclock secs (1011.13 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for create_key+drop (7000): 1025 wallclock secs (1025.23 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Total time: 9601 wallclock secs (9600.98 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/create-mysql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/create-mysql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..726d05c2881 --- /dev/null +++ b/sql-bench/Results-win32/create-mysql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,20 @@ +Testing server 'MySQL 3.22.16 gamma' at 1999-02-07 11:53:20 + +Testing the speed of creating and droping tables +All tests are done 1000 times + +Okay..Let's make sure that our tables don't exist yet. + +Testing create of tables +Time for create_table (1000): 22 secs (21.84 usr 0.00 sys = 21.84 cpu) + +Accessing tables +Time to select_group (1000): 17 secs (17.75 usr 0.00 sys = 17.75 cpu) + +Testing drop +Time for drop_table (1000): 4 secs ( 3.73 usr 0.00 sys = 3.73 cpu) + +Testing create+drop +Time for create+drop (1000): 15 secs (15.21 usr 0.00 sys = 15.21 cpu) +Time for create_key+drop (1000): 20 secs (20.05 usr 0.00 sys = 20.05 cpu) +Total time: 78 secs (78.59 usr 0.00 sys = 78.59 cpu) diff --git a/sql-bench/Results-win32/create-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/create-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..71177a8d45a --- /dev/null +++ b/sql-bench/Results-win32/create-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,20 @@ +Testing server 'Oracle 8.0.4.0.0' at 1999-04-04 3:34:22
+
+Testing the speed of creating and droping tables
+All tests are done 1000 times
+
+Okay..Let's make sure that our tables don't exist yet.
+
+Testing create of tables
+Time for create_table (1000): 132 wallclock secs ( 3.33 usr 0.37 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Accessing tables
+Time to select_group (1000): 7 wallclock secs ( 1.52 usr 0.12 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing drop
+Time for drop_table (1000): 108 wallclock secs ( 1.31 usr 0.17 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing create+drop
+Time for create+drop (1000): 288 wallclock secs ( 4.23 usr 0.58 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for create_key+drop (1000): 411 wallclock secs ( 4.65 usr 0.38 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Total time: 947 wallclock secs (15.04 usr 1.62 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/create-solid_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/create-solid_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..038dd13cf5f --- /dev/null +++ b/sql-bench/Results-win32/create-solid_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,20 @@ +Testing server 'Solid version ???' at 1998-10-06 18:19:13 + +Testing the speed of creating and droping tables +All tests are done 1000 times + +Okay..Let's make sure that our tables don't exist yet. + +Testing create of tables +Time for create_table (1000): 22 secs (21.35 usr 0.00 sys = 21.35 cpu) + +Accessing tables +Time to select_group (1000): 8 secs ( 8.23 usr 0.00 sys = 8.23 cpu) + +Testing drop +Time for drop_table (1000): 18 secs (17.98 usr 0.00 sys = 17.98 cpu) + +Testing create+drop +Time for create+drop (1000): 41 secs (41.20 usr 0.00 sys = 41.20 cpu) +Time for create_key+drop (1000): 72 secs (72.18 usr 0.00 sys = 72.18 cpu) +Total time: 161 secs (160.95 usr 0.00 sys = 160.95 cpu) diff --git a/sql-bench/Results-win32/create-sybase_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/create-sybase_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..242fe125667 --- /dev/null +++ b/sql-bench/Results-win32/create-sybase_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,20 @@ +Testing server 'Sybase enterprise 11.5 NT' at 1998-08-27 3:05:28 + +Testing the speed of creating and droping tables +All tests are done 1000 times + +Okay..Let's make sure that our tables don't exist yet. + +Testing create of tables +Time for create_table (1000): 80 secs (80.37 usr 0.00 sys = 80.37 cpu) + +Accessing tables +Time to select_group (1000): 14 secs (14.25 usr 0.00 sys = 14.25 cpu) + +Testing drop +Time for drop_table (1000): 19 secs (18.63 usr 0.00 sys = 18.63 cpu) + +Testing create+drop +Time for create+drop (1000): 63 secs (63.53 usr 0.00 sys = 63.53 cpu) +Time for create_key+drop (1000): 52 secs (51.41 usr 0.00 sys = 51.41 cpu) +Total time: 228 secs (228.22 usr 0.00 sys = 228.22 cpu) diff --git a/sql-bench/Results-win32/insert-access_odbc-win98-cmp-access,mysql b/sql-bench/Results-win32/insert-access_odbc-win98-cmp-access,mysql new file mode 100644 index 00000000000..88b87322eaa --- /dev/null +++ b/sql-bench/Results-win32/insert-access_odbc-win98-cmp-access,mysql @@ -0,0 +1,67 @@ +Testing server 'Access 2000' at 2000-01-03 15:01:30
+
+Testing the speed of inserting data into 1 table and do some selects on it.
+The tests are done with a table that has 100000 rows.
+
+Generating random keys
+Creating tables
+Inserting 100000 rows in order
+Inserting 100000 rows in reverse order
+Inserting 100000 rows in random order
+Time for insert (300000): 1974 wallclock secs (1973.91 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing insert of duplicates
+Time for insert_duplicates (300000): 209 wallclock secs (208.61 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Retrieving data from the table
+Time for select_big (10:3000000): 311 wallclock secs (310.93 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for order_by_key (10:3000000): 396 wallclock secs (395.80 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for order_by (10:3000000): 388 wallclock secs (388.10 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_diff_key (500:1000): 3 wallclock secs ( 3.63 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_range_prefix (5010:42084): 68 wallclock secs (67.77 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_range (5010:42084): 65 wallclock secs (64.65 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Note: Query took longer then time-limit: 600
+Estimating end time based on:
+71768 queries in 35884 loops of 100000 loops took 601 seconds
+Estimated time for select_key_prefix (200000): 1674 wallclock secs (1673.75 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Note: Query took longer then time-limit: 600
+Estimating end time based on:
+58230 queries in 29115 loops of 100000 loops took 601 seconds
+Estimated time for select_key (200000): 2064 wallclock secs (2064.23 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Test of compares with simple ranges
+Note: Query took longer then time-limit: 600
+Estimating end time based on:
+5960 queries in 149 loops of 500 loops took 603 seconds
+Estimated time for select_range_prefix (20000:12963): 2023 wallclock secs (2024.87 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_range (20000:43500): 475 wallclock secs (474.78 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_group (91): 341 wallclock secs (341.20 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for min_max_on_key (3000): 19 wallclock secs (18.56 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for min_max (60): 186 wallclock secs (186.25 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for count_on_key (100): 15 wallclock secs (15.44 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for count (100): 328 wallclock secs (327.46 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing update of keys with functions
+Time for update_of_key (500): 14 wallclock secs (14.12 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for update_of_key_big (501): 548 wallclock secs (548.43 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing update with key
+Time for update_with_key (100000): 2081 wallclock secs (2080.30 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing update of all rows
+Time for update_big (500): 1550 wallclock secs (1550.11 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing delete
+Time for delete_key (500): 79 wallclock secs (79.31 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for delete_big (12): 274 wallclock secs (274.25 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Insert into table with 16 keys and with a primary key with 10 parts
+Time for insert_key (100000): 10591 wallclock secs (10591.45 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing update of keys
+Time for update_of_key (256): 873 wallclock secs (872.99 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Deleting everything from table
+Time for delete_big_many_keys (2): 12569 wallclock secs (12568.66 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Estimated total time: 39293 wallclock secs (39294.15 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/insert-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/insert-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..4537891dcbf --- /dev/null +++ b/sql-bench/Results-win32/insert-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,99 @@ +Testing server 'IBM DB2 5' at 1999-02-02 0:15:24 + +Testing the speed of inserting data into 1 table and do some selects on it. +The tests are done with a table that has 100000 rows. + +Generating random keys +Creating tables +Inserting 100000 rows in order +0 : Tue Feb 2 00:15:41 1999 +10000 : Tue Feb 2 00:17:14 1999 +20000 : Tue Feb 2 00:18:48 1999 +30000 : Tue Feb 2 00:20:23 1999 +40000 : Tue Feb 2 00:22:02 1999 +50000 : Tue Feb 2 00:23:40 1999 +60000 : Tue Feb 2 00:25:16 1999 +70000 : Tue Feb 2 00:26:54 1999 +80000 : Tue Feb 2 00:28:31 1999 +90000 : Tue Feb 2 00:30:05 1999 +Inserting 100000 rows in reverse order +0 : Tue Feb 2 00:31:40 1999 +10000 : Tue Feb 2 00:33:22 1999 +20000 : Tue Feb 2 00:34:59 1999 +30000 : Tue Feb 2 00:36:34 1999 +40000 : Tue Feb 2 00:38:18 1999 +50000 : Tue Feb 2 00:39:54 1999 +60000 : Tue Feb 2 00:41:29 1999 +70000 : Tue Feb 2 00:43:13 1999 +80000 : Tue Feb 2 00:44:49 1999 +90000 : Tue Feb 2 00:46:25 1999 +Inserting 100000 rows in random order +0 : Tue Feb 2 00:48:02 1999 +10000 : Tue Feb 2 00:49:44 1999 +20000 : Tue Feb 2 00:51:21 1999 +30000 : Tue Feb 2 00:53:01 1999 +40000 : Tue Feb 2 00:54:42 1999 +50000 : Tue Feb 2 00:56:16 1999 +60000 : Tue Feb 2 00:57:52 1999 +70000 : Tue Feb 2 00:59:38 1999 +80000 : Tue Feb 2 01:01:12 1999 +90000 : Tue Feb 2 01:02:47 1999 +Time for insert (300000): 2932 secs (2932.59 usr 0.00 sys = 2932.59 cpu) + +Testing insert of duplicates +Time for insert_duplicates (300000): 353 secs (353.39 usr 0.00 sys = 353.39 cpu) + +Retrieving data from the table +Time for select_big (10:3000000): 379 secs (379.32 usr 0.00 sys = 379.32 cpu) +Time for order_by_key (10:3000000): 369 secs (368.78 usr 0.00 sys = 368.78 cpu) +Time for order_by (10:3000000): 361 secs (361.08 usr 0.00 sys = 361.08 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +1940 queries in 1940 loops of 5000 loops took 601 seconds +Estimated time for select_range_prefix (5000:7760): 1548 secs (1548.93 usr 0.00 sys = 1548.93 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +1950 queries in 1950 loops of 5000 loops took 602 seconds +Estimated time for select_range (5000:7800): 1543 secs (1542.09 usr 0.00 sys = 1542.09 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +100196 queries in 50098 loops of 100000 loops took 601 seconds +Estimated time for select_key_prefix (200000): 1199 secs (1199.40 usr 0.00 sys = 1199.40 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +99640 queries in 49820 loops of 100000 loops took 601 seconds +Estimated time for select_key (200000): 1206 secs (1206.37 usr 0.00 sys = 1206.37 cpu) + +Test of compares with simple ranges +Note: Query took longer then time-limit: 600 +Estimating end time based on: +8320 queries in 208 loops of 500 loops took 602 seconds +Estimated time for select_range_prefix (20000:18096): 602 secs (602.91 usr 0.00 sys = 602.91 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +8280 queries in 207 loops of 500 loops took 603 seconds +Estimated time for select_range (20000:18009): 603 secs (602.74 usr 0.00 sys = 602.74 cpu) +Time for select_group (91): 145 secs (144.82 usr 0.00 sys = 144.82 cpu) +Time for min_max_on_key (3000): 576 secs (575.99 usr 0.00 sys = 575.99 cpu) +Time for min_max (60): 56 secs (55.56 usr 0.00 sys = 55.56 cpu) +Time for count_on_key (100): 58 secs (57.98 usr 0.00 sys = 57.98 cpu) +Time for count (100): 87 secs (87.24 usr 0.00 sys = 87.24 cpu) + +Testing update with functions +Time for update_key (500): 5 secs ( 5.24 usr 0.00 sys = 5.24 cpu) +Time for update_key_big (501): 542 secs (542.23 usr 0.00 sys = 542.23 cpu) + +Testing delete +Time for delete_key (500): 16 secs (15.97 usr 0.00 sys = 15.97 cpu) +Time for delete_big (12): 133 secs (133.19 usr 0.00 sys = 133.19 cpu) + +Insert into table with 16 keys and with a primary key with 15 parts +Time for insert_key (100000): 2484 secs (2484.63 usr 0.00 sys = 2484.63 cpu) + +Testing update of keys +Time for update_of_key (256): 175 secs (174.76 usr 0.00 sys = 174.76 cpu) + +Deleting everything from table +Time for delete_big (2): 316 secs (315.91 usr 0.00 sys = 315.91 cpu) + +Estimated total time: 17508 secs (17508.04 usr 0.00 sys = 17508.04 cpu) diff --git a/sql-bench/Results-win32/insert-informix_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/insert-informix_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..9a8e755e9b8 --- /dev/null +++ b/sql-bench/Results-win32/insert-informix_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,102 @@ +Testing server 'Informix 7.30C1 ' at 1998-10-05 15:25:46 + +Testing the speed of inserting data into 1 table and do some selects on it. +The tests are done with a table that has 100000 rows. + +Generating random keys +Creating tables +Inserting 100000 rows in order +0 : Mon Oct 5 15:25:50 1998 +10000 : Mon Oct 5 15:26:40 1998 +20000 : Mon Oct 5 15:27:31 1998 +30000 : Mon Oct 5 15:28:22 1998 +40000 : Mon Oct 5 15:29:14 1998 +50000 : Mon Oct 5 15:30:04 1998 +60000 : Mon Oct 5 15:30:55 1998 +70000 : Mon Oct 5 15:31:45 1998 +80000 : Mon Oct 5 15:32:36 1998 +90000 : Mon Oct 5 15:33:26 1998 +Inserting 100000 rows in reverse order +0 : Mon Oct 5 15:34:17 1998 +10000 : Mon Oct 5 15:35:08 1998 +20000 : Mon Oct 5 15:36:00 1998 +30000 : Mon Oct 5 15:36:51 1998 +40000 : Mon Oct 5 15:37:43 1998 +50000 : Mon Oct 5 15:38:34 1998 +60000 : Mon Oct 5 15:39:26 1998 +70000 : Mon Oct 5 15:40:18 1998 +80000 : Mon Oct 5 15:41:10 1998 +90000 : Mon Oct 5 15:42:01 1998 +Inserting 100000 rows in random order +0 : Mon Oct 5 15:42:53 1998 +10000 : Mon Oct 5 15:43:45 1998 +20000 : Mon Oct 5 15:44:36 1998 +30000 : Mon Oct 5 15:45:31 1998 +40000 : Mon Oct 5 15:47:13 1998 +50000 : Mon Oct 5 15:49:41 1998 +60000 : Mon Oct 5 15:52:40 1998 +70000 : Mon Oct 5 15:55:47 1998 +80000 : Mon Oct 5 15:59:09 1998 +90000 : Mon Oct 5 16:02:35 1998 +Time for insert (300000): 2417 secs (2417.46 usr 0.00 sys = 2417.46 cpu) + +Testing insert of duplicates +Time for insert_duplicates (300000): 280 secs (280.34 usr 0.00 sys = 280.34 cpu) + +Retrieving data from the table +Time for select_big (10:3000000): 495 secs (494.46 usr 0.00 sys = 494.46 cpu) +Time for order_by_key (10:3000000): 485 secs (485.49 usr 0.00 sys = 485.49 cpu) +Time for order_by (10:3000000): 518 secs (517.79 usr 0.00 sys = 517.79 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +440 queries in 440 loops of 5000 loops took 602 seconds +Estimated time for select_range_prefix (5000:1760): 6840 secs (6840.98 usr 0.00 sys = 6840.98 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +460 queries in 460 loops of 5000 loops took 613 seconds +Estimated time for select_range (5000:1840): 6663 secs (6665.89 usr 0.00 sys = 6665.89 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +1002 queries in 501 loops of 100000 loops took 601 seconds +Estimated time for select_key_prefix (200000): 119960 secs (119942.91 usr 0.00 sys = 119942.91 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +994 queries in 497 loops of 100000 loops took 602 seconds +Estimated time for select_key (200000): 121126 secs (120992.76 usr 0.00 sys = 120992.76 cpu) + +Test of compares with simple ranges +Note: Query took longer then time-limit: 600 +Estimating end time based on: +1360 queries in 34 loops of 500 loops took 608 seconds +Estimated time for select_range_prefix (20000:2958): 608 secs (608.02 usr 0.00 sys = 608.02 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +1360 queries in 34 loops of 500 loops took 615 seconds +Estimated time for select_range (20000:2958): 615 secs (615.40 usr 0.00 sys = 615.40 cpu) +Time for select_group (91): 896 secs (895.47 usr 0.00 sys = 895.47 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +2964 queries in 494 loops of 500 loops took 601 seconds +Estimated time for min_max_on_key (3000): 608 secs (608.68 usr 0.00 sys = 608.68 cpu) +Time for min_max (60): 344 secs (344.44 usr 0.00 sys = 344.44 cpu) +Time for count_on_key (100): 931 secs (930.38 usr 0.00 sys = 930.38 cpu) +Time for count (100): 116 secs (115.85 usr 0.00 sys = 115.85 cpu) + +Testing update with functions +Time for update_key (500): 771 secs (771.67 usr 0.00 sys = 771.67 cpu) +Time for update_key_big (501): 3000 secs (2999.42 usr 0.00 sys = 2999.42 cpu) + +Testing delete +Time for delete_key (500): 738 secs (737.82 usr 0.00 sys = 737.82 cpu) +Time for delete_big (12): 929 secs (928.69 usr 0.00 sys = 928.69 cpu) + +Insert into table with 16 keys and with a primary key with 15 parts +Time for insert_key (100000): 8231 secs (8231.23 usr 0.00 sys = 8231.23 cpu) + +Testing update of keys +Time for update_of_key (256): 2190 secs (2190.23 usr 0.00 sys = 2190.23 cpu) + +Deleting everything from table +Time for delete_big (2): 10326 secs (10325.87 usr 0.00 sys = 10325.87 cpu) + +Estimated total time: 305853 secs (305711.97 usr 0.00 sys = 305711.97 cpu) diff --git a/sql-bench/Results-win32/insert-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/insert-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..c32fb0d0b4c --- /dev/null +++ b/sql-bench/Results-win32/insert-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,57 @@ +Testing server 'Microsoft SQL Server 7.00 - 7.00.517 (Intel X86) ' at 1998-09-27 10:54:53 + +Testing the speed of inserting data into 1 table and do some selects on it. +The tests are done with a table that has 100000 rows. + +Generating random keys +Creating tables +Inserting 100000 rows in order +Inserting 100000 rows in reverse order +Inserting 100000 rows in random order +Time for insert (300000): 3592 secs (3591.82 usr 0.00 sys = 3591.82 cpu) + +Testing insert of duplicates +Time for insert_duplicates (300000): 286 secs (285.70 usr 0.00 sys = 285.70 cpu) + +Retrieving data from the table +Time for select_big (10:3000000): 202 secs (202.02 usr 0.00 sys = 202.02 cpu) +Time for order_by_key (10:3000000): 201 secs (200.90 usr 0.00 sys = 200.90 cpu) +Time for order_by (10:3000000): 250 secs (250.66 usr 0.00 sys = 250.66 cpu) +Time for select_range_prefix (5000:20000): 25 secs (25.49 usr 0.00 sys = 25.49 cpu) +Time for select_range (5000:20000): 24 secs (24.02 usr 0.00 sys = 24.02 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +70770 queries in 35385 loops of 100000 loops took 601 seconds +Estimated time for select_key_prefix (200000): 1698 secs (1696.55 usr 0.00 sys = 1696.55 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +73534 queries in 36767 loops of 100000 loops took 601 seconds +Estimated time for select_key (200000): 1634 secs (1634.55 usr 0.00 sys = 1634.55 cpu) + +Test of compares with simple ranges +Time for select_range_prefix (20000:43500): 43 secs (43.59 usr 0.00 sys = 43.59 cpu) +Time for select_range (20000:43500): 44 secs (43.58 usr 0.00 sys = 43.58 cpu) +Time for select_group (91): 75 secs (75.48 usr 0.00 sys = 75.48 cpu) +Time for min_max_on_key (3000): 25 secs (24.60 usr 0.00 sys = 24.60 cpu) +Time for min_max (60): 115 secs (115.58 usr 0.00 sys = 115.58 cpu) +Time for count_on_key (100): 18 secs (17.22 usr 0.00 sys = 17.22 cpu) +Time for count (100): 49 secs (49.15 usr 0.00 sys = 49.15 cpu) + +Testing update with functions +Time for update_key (500): 8 secs ( 8.00 usr 0.00 sys = 8.00 cpu) +Time for update_key_big (501): 403 secs (402.89 usr 0.00 sys = 402.89 cpu) + +Testing delete +Time for delete_key (500): 21 secs (21.33 usr 0.00 sys = 21.33 cpu) +Time for delete_big (12): 186 secs (186.21 usr 0.00 sys = 186.21 cpu) + +Insert into table with 16 keys and with a primary key with 15 parts +Time for insert_key (100000): 5181 secs (5181.56 usr 0.00 sys = 5181.56 cpu) + +Testing update of keys +Time for update_of_key (256): 674 secs (674.29 usr 0.00 sys = 674.29 cpu) + +Deleting everything from table +Time for delete_big (2): 687 secs (686.86 usr 0.00 sys = 686.86 cpu) + +Estimated total time: 15454 secs (15453.34 usr 0.00 sys = 15453.34 cpu) diff --git a/sql-bench/Results-win32/insert-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/insert-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..4782dc717df --- /dev/null +++ b/sql-bench/Results-win32/insert-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,81 @@ +Testing server 'MySQL 3.22.16 gamma' at 1999-02-20 19:59:21 + +Testing the speed of inserting data into 1 table and do some selects on it. +The tests are done with a table that has 100000 rows. + +Generating random keys +Creating tables +Inserting 100000 rows in order +0 : Sat Feb 20 19:59:22 1999 +10000 : Sat Feb 20 19:59:33 1999 +20000 : Sat Feb 20 19:59:43 1999 +30000 : Sat Feb 20 19:59:54 1999 +40000 : Sat Feb 20 20:00:05 1999 +50000 : Sat Feb 20 20:00:15 1999 +60000 : Sat Feb 20 20:00:26 1999 +70000 : Sat Feb 20 20:00:37 1999 +80000 : Sat Feb 20 20:00:48 1999 +90000 : Sat Feb 20 20:01:00 1999 +Inserting 100000 rows in reverse order +0 : Sat Feb 20 20:01:11 1999 +10000 : Sat Feb 20 20:01:22 1999 +20000 : Sat Feb 20 20:01:33 1999 +30000 : Sat Feb 20 20:01:44 1999 +40000 : Sat Feb 20 20:01:55 1999 +50000 : Sat Feb 20 20:02:06 1999 +60000 : Sat Feb 20 20:02:18 1999 +70000 : Sat Feb 20 20:02:29 1999 +80000 : Sat Feb 20 20:02:40 1999 +90000 : Sat Feb 20 20:02:51 1999 +Inserting 100000 rows in random order +0 : Sat Feb 20 20:03:02 1999 +10000 : Sat Feb 20 20:03:13 1999 +20000 : Sat Feb 20 20:03:24 1999 +30000 : Sat Feb 20 20:03:36 1999 +40000 : Sat Feb 20 20:03:47 1999 +50000 : Sat Feb 20 20:03:58 1999 +60000 : Sat Feb 20 20:04:09 1999 +70000 : Sat Feb 20 20:04:20 1999 +80000 : Sat Feb 20 20:04:31 1999 +90000 : Sat Feb 20 20:04:42 1999 +Time for insert (300000): 332 wallclock secs (58.41 usr + 41.64 sys = 100.05 CPU) + +Testing insert of duplicates +Time for insert_duplicates (300000): 68 wallclock secs (16.34 usr + 13.36 sys = 29.70 CPU) + +Retrieving data from the table +Time for select_big (10:3000000): 73 wallclock secs (41.15 usr + 19.92 sys = 61.07 CPU) +Time for order_by_key (10:3000000): 73 wallclock secs (40.79 usr + 20.33 sys = 61.12 CPU) +Time for order_by (10:3000000): 100 wallclock secs (40.72 usr + 19.97 sys = 60.69 CPU) +Time for select_range_prefix (5000:20000): 12 wallclock secs ( 4.27 usr + 0.95 sys = 5.22 CPU) +Time for select_range (5000:20000): 13 wallclock secs ( 4.34 usr + 1.00 sys = 5.34 CPU) +Time for select_key_prefix (200000): 375 wallclock secs (158.15 usr + 38.91 sys = 197.05 CPU) +Time for select_key (200000): 367 wallclock secs (157.27 usr + 40.25 sys = 197.51 CPU) + +Test of compares with simple ranges +Time for select_range_prefix (20000:43500): 22 wallclock secs ( 8.37 usr + 2.09 sys = 10.46 CPU) +Time for select_range (20000:43500): 22 wallclock secs ( 8.39 usr + 2.31 sys = 10.71 CPU) +Time for select_group (91): 27 wallclock secs ( 0.06 usr + 0.01 sys = 0.07 CPU) +Time for min_max_on_key (3000): 4 wallclock secs ( 2.17 usr + 0.59 sys = 2.76 CPU) +Time for min_max (60): 26 wallclock secs ( 0.06 usr + 0.01 sys = 0.07 CPU) +Time for count_on_key (100): 31 wallclock secs ( 0.08 usr + 0.04 sys = 0.12 CPU) +Time for count (100): 54 wallclock secs ( 0.06 usr + 0.01 sys = 0.07 CPU) + +Testing update with functions +Time for update_key (500): 0 wallclock secs ( 0.09 usr + 0.05 sys = 0.14 CPU) +Time for update_key_big (501): 26 wallclock secs ( 0.10 usr + 0.06 sys = 0.16 CPU) + +Testing delete +Time for delete_key (500): 1 wallclock secs ( 0.10 usr + 0.08 sys = 0.18 CPU) +Time for delete_big (12): 14 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) + +Insert into table with 16 keys and with a primary key with 15 parts +Time for insert_key (100000): 2906 wallclock secs (27.77 usr + 14.64 sys = 42.41 CPU) + +Testing update of keys +Time for update_of_key (256): 157 wallclock secs ( 0.04 usr + 0.04 sys = 0.08 CPU) + +Deleting everything from table +Time for delete_big (2): 663 wallclock secs ( 0.01 usr + 0.00 sys = 0.01 CPU) + +Total time: 5368 wallclock secs (568.77 usr + 216.27 sys = 785.04 CPU) diff --git a/sql-bench/Results-win32/insert-mysql-win98 b/sql-bench/Results-win32/insert-mysql-win98 new file mode 100644 index 00000000000..12c85e60dee --- /dev/null +++ b/sql-bench/Results-win32/insert-mysql-win98 @@ -0,0 +1,72 @@ +Testing server 'MySQL 3.23.13a alpha' at 2000-03-15 3:59:00
+
+Testing the speed of inserting data into 1 table and do some selects on it.
+The tests are done with a table that has 100000 rows.
+
+Generating random keys
+Creating tables
+Inserting 100000 rows in order
+Inserting 100000 rows in reverse order
+Inserting 100000 rows in random order
+Time for insert (300000): 438 wallclock secs (437.15 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing insert of duplicates
+Time for insert_duplicates (300000): 91 wallclock secs (91.06 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Retrieving data from the table
+Time for select_big (10:3000000): 173 wallclock secs (173.79 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for order_by_key (10:3000000): 175 wallclock secs (174.66 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for order_by (10:3000000): 249 wallclock secs (248.87 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_diff_key (500:1000): 241 wallclock secs (240.63 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_range_prefix (5010:42084): 33 wallclock secs (33.50 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_range (5010:42084): 34 wallclock secs (33.67 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_key_prefix (200000): 542 wallclock secs (542.23 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_key (200000): 540 wallclock secs (540.35 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Test of compares with simple ranges
+Time for select_range_prefix (20000:43500): 33 wallclock secs (33.12 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_range (20000:43500): 33 wallclock secs (33.45 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_group (111): 58 wallclock secs (58.22 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for min_max_on_key (3000): 7 wallclock secs ( 6.87 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for min_max (60): 33 wallclock secs (32.90 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for count_on_key (100): 52 wallclock secs (52.23 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for count (100): 55 wallclock secs (54.87 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing update of keys with functions
+Time for update_of_key (500): 1 wallclock secs ( 0.99 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for update_of_key_big (501): 38 wallclock secs (38.07 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing update with key
+Time for update_with_key (100000): 432 wallclock secs (432.20 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing update of all rows
+Time for update_big (500): 84 wallclock secs (83.33 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing left outer join
+Time for outer_join_on_key (10:10): 63 wallclock secs (63.33 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for outer_join (10:10): 146 wallclock secs (145.66 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for outer_join_found (10:10): 144 wallclock secs (144.40 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Note: Query took longer then time-limit: 600
+Estimating end time based on:
+75 queries in 74 loops of 500 loops took 606 seconds
+Estimated time for outer_join_not_found (500:506): 606 wallclock secs (605.55 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing delete
+Time for delete_key (500): 0 wallclock secs ( 0.82 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for delete_big (12): 22 wallclock secs (21.59 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Insert into table with 16 keys and with a primary key with 16 parts
+Time for insert_key (100000): 364 wallclock secs (363.72 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing update of keys
+Time for update_of_key (256): 58 wallclock secs (58.22 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Deleting everything from table
+Time for delete_big_many_keys (2): 112 wallclock secs (112.11 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Inserting 100000 rows with multiple values
+Time for multiple_value_insert (100000): 11 wallclock secs (11.64 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Time for drop table(1): 0 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Estimated total time: 8358 wallclock secs (8356.07 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/insert-mysql-win98-cmp-access,mysql b/sql-bench/Results-win32/insert-mysql-win98-cmp-access,mysql new file mode 100644 index 00000000000..f45c0f45f36 --- /dev/null +++ b/sql-bench/Results-win32/insert-mysql-win98-cmp-access,mysql @@ -0,0 +1,64 @@ +Testing server 'MySQL 3.23.8 alpha' at 2000-01-04 12:26:26
+
+Testing the speed of inserting data into 1 table and do some selects on it.
+The tests are done with a table that has 100000 rows.
+
+Generating random keys
+Creating tables
+Inserting 100000 rows in order
+Inserting 100000 rows in reverse order
+Inserting 100000 rows in random order
+Time for insert (300000): 486 wallclock secs (486.04 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing insert of duplicates
+Time for insert_duplicates (300000): 107 wallclock secs (106.89 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Retrieving data from the table
+Time for select_big (10:3000000): 192 wallclock secs (191.85 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for order_by_key (10:3000000): 192 wallclock secs (192.79 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for order_by (10:3000000): 282 wallclock secs (281.88 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_diff_key (500:1000): 264 wallclock secs (263.97 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_range_prefix (5010:42084): 38 wallclock secs (37.95 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_range (5010:42084): 38 wallclock secs (38.06 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Note: Query took longer then time-limit: 600
+Estimating end time based on:
+188074 queries in 94037 loops of 100000 loops took 601 seconds
+Estimated time for select_key_prefix (200000): 639 wallclock secs (638.34 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Note: Query took longer then time-limit: 600
+Estimating end time based on:
+189130 queries in 94565 loops of 100000 loops took 601 seconds
+Estimated time for select_key (200000): 635 wallclock secs (635.54 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Test of compares with simple ranges
+Time for select_range_prefix (20000:43500): 38 wallclock secs (38.28 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_range (20000:43500): 38 wallclock secs (38.62 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_group (91): 40 wallclock secs (39.38 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for min_max_on_key (3000): 8 wallclock secs ( 7.96 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for min_max (60): 34 wallclock secs (33.78 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for count_on_key (100): 54 wallclock secs (54.27 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for count (100): 58 wallclock secs (57.94 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing update of keys with functions
+Time for update_of_key (500): 1 wallclock secs ( 1.16 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for update_of_key_big (501): 40 wallclock secs (39.93 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing update with key
+Time for update_with_key (100000): 485 wallclock secs (484.77 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing update of all rows
+Time for update_big (500): 96 wallclock secs (96.78 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing delete
+Time for delete_key (500): 1 wallclock secs ( 0.93 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for delete_big (12): 27 wallclock secs (26.15 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Insert into table with 16 keys and with a primary key with 10 parts
+Time for insert_key (100000): 367 wallclock secs (367.34 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing update of keys
+Time for update_of_key (256): 53 wallclock secs (52.84 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Deleting everything from table
+Time for delete_big_many_keys (2): 102 wallclock secs (102.60 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Estimated total time: 4315 wallclock secs (4316.21 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/insert-mysql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/insert-mysql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..5149348b5d4 --- /dev/null +++ b/sql-bench/Results-win32/insert-mysql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,81 @@ +Testing server 'MySQL 3.22.16 gamma' at 1999-02-07 11:54:41 + +Testing the speed of inserting data into 1 table and do some selects on it. +The tests are done with a table that has 100000 rows. + +Generating random keys +Creating tables +Inserting 100000 rows in order +0 : Sun Feb 7 11:54:43 1999 +10000 : Sun Feb 7 11:55:01 1999 +20000 : Sun Feb 7 11:55:18 1999 +30000 : Sun Feb 7 11:55:36 1999 +40000 : Sun Feb 7 11:55:53 1999 +50000 : Sun Feb 7 11:56:11 1999 +60000 : Sun Feb 7 11:56:28 1999 +70000 : Sun Feb 7 11:56:46 1999 +80000 : Sun Feb 7 11:57:03 1999 +90000 : Sun Feb 7 11:57:21 1999 +Inserting 100000 rows in reverse order +0 : Sun Feb 7 11:57:38 1999 +10000 : Sun Feb 7 11:57:56 1999 +20000 : Sun Feb 7 11:58:14 1999 +30000 : Sun Feb 7 11:58:32 1999 +40000 : Sun Feb 7 11:58:50 1999 +50000 : Sun Feb 7 11:59:08 1999 +60000 : Sun Feb 7 11:59:26 1999 +70000 : Sun Feb 7 11:59:44 1999 +80000 : Sun Feb 7 12:00:03 1999 +90000 : Sun Feb 7 12:00:21 1999 +Inserting 100000 rows in random order +0 : Sun Feb 7 12:00:39 1999 +10000 : Sun Feb 7 12:00:57 1999 +20000 : Sun Feb 7 12:01:15 1999 +30000 : Sun Feb 7 12:01:33 1999 +40000 : Sun Feb 7 12:01:51 1999 +50000 : Sun Feb 7 12:02:09 1999 +60000 : Sun Feb 7 12:02:27 1999 +70000 : Sun Feb 7 12:02:45 1999 +80000 : Sun Feb 7 12:03:03 1999 +90000 : Sun Feb 7 12:03:21 1999 +Time for insert (300000): 536 secs (535.99 usr 0.00 sys = 535.99 cpu) + +Testing insert of duplicates +Time for insert_duplicates (300000): 144 secs (143.90 usr 0.00 sys = 143.90 cpu) + +Retrieving data from the table +Time for select_big (10:3000000): 354 secs (353.98 usr 0.00 sys = 353.98 cpu) +Time for order_by_key (10:3000000): 355 secs (355.39 usr 0.00 sys = 355.39 cpu) +Time for order_by (10:3000000): 382 secs (381.52 usr 0.00 sys = 381.52 cpu) +Time for select_range_prefix (5000:20000): 18 secs (17.77 usr 0.00 sys = 17.77 cpu) +Time for select_range (5000:20000): 18 secs (17.89 usr 0.00 sys = 17.89 cpu) +Time for select_key_prefix (200000): 470 secs (470.56 usr 0.00 sys = 470.56 cpu) +Time for select_key (200000): 464 secs (463.54 usr 0.00 sys = 463.54 cpu) + +Test of compares with simple ranges +Time for select_range_prefix (20000:43500): 33 secs (32.88 usr 0.00 sys = 32.88 cpu) +Time for select_range (20000:43500): 32 secs (32.18 usr 0.00 sys = 32.18 cpu) +Time for select_group (91): 28 secs (28.33 usr 0.00 sys = 28.33 cpu) +Time for min_max_on_key (3000): 7 secs ( 6.69 usr 0.00 sys = 6.69 cpu) +Time for min_max (60): 28 secs (28.04 usr 0.00 sys = 28.04 cpu) +Time for count_on_key (100): 34 secs (33.86 usr 0.00 sys = 33.86 cpu) +Time for count (100): 58 secs (58.27 usr 0.00 sys = 58.27 cpu) + +Testing update with functions +Time for update_key (500): 1 secs ( 0.95 usr 0.00 sys = 0.95 cpu) +Time for update_key_big (501): 26 secs (26.35 usr 0.00 sys = 26.35 cpu) + +Testing delete +Time for delete_key (500): 2 secs ( 1.83 usr 0.00 sys = 1.83 cpu) +Time for delete_big (12): 15 secs (15.01 usr 0.00 sys = 15.01 cpu) + +Insert into table with 16 keys and with a primary key with 15 parts +Time for insert_key (100000): 2908 secs (2907.97 usr 0.00 sys = 2907.97 cpu) + +Testing update of keys +Time for update_of_key (256): 164 secs (163.52 usr 0.00 sys = 163.52 cpu) + +Deleting everything from table +Time for delete_big (2): 665 secs (665.36 usr 0.00 sys = 665.36 cpu) + +Total time: 6744 secs (6743.40 usr 0.00 sys = 6743.40 cpu) diff --git a/sql-bench/Results-win32/insert-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/insert-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..03c00927dcc --- /dev/null +++ b/sql-bench/Results-win32/insert-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,69 @@ +Testing server 'Oracle 8.0.4.0.0' at 1999-04-04 3:50:22
+
+Testing the speed of inserting data into 1 table and do some selects on it.
+The tests are done with a table that has 100000 rows.
+
+Generating random keys
+Creating tables
+Inserting 100000 rows in order
+Inserting 100000 rows in reverse order
+Inserting 100000 rows in random order
+Time for insert (300000): 2511 wallclock secs (425.27 usr 50.44 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing insert of duplicates
+Time for insert_duplicates (300000): 353 wallclock secs (195.15 usr 26.95 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Retrieving data from the table
+Time for select_big (10:3000000): 1130 wallclock secs (575.36 usr 100.01 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Note: Query took longer then time-limit: 600
+Estimating end time based on:
+6 queries in 6 loops of 10 loops took 675 seconds
+Estimated time for order_by_key (10:1800000): 1125 wallclock secs (580.64 usr 95.55 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Note: Query took longer then time-limit: 600
+Estimating end time based on:
+6 queries in 6 loops of 10 loops took 659 seconds
+Estimated time for order_by (10:1800000): 1098 wallclock secs (570.85 usr 95.67 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_range_prefix (5000:20000): 31 wallclock secs (18.04 usr 3.01 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Note: Query took longer then time-limit: 600
+Estimating end time based on:
+410 queries in 410 loops of 5000 loops took 608 seconds
+Estimated time for select_range (5000:1640): 7414 wallclock secs (19.17 usr 3.06 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Note: Query took longer then time-limit: 600
+Estimating end time based on:
+115830 queries in 57915 loops of 100000 loops took 601 seconds
+Estimated time for select_key_prefix (200000): 1037 wallclock secs (576.33 usr 93.13 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Note: Query took longer then time-limit: 600
+Estimating end time based on:
+1384 queries in 692 loops of 100000 loops took 601 seconds
+Estimated time for select_key (200000): 86849 wallclock secs (639.74 usr 105.64 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Test of compares with simple ranges
+Time for select_range_prefix (20000:43500): 64 wallclock secs (40.72 usr 5.17 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Note: Query took longer then time-limit: 600
+Estimating end time based on:
+1400 queries in 35 loops of 500 loops took 605 seconds
+Estimated time for select_range (20000:3045): 605 wallclock secs ( 3.09 usr 0.29 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_group (91): 45 wallclock secs ( 0.15 usr 0.08 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for min_max_on_key (3000): 15 wallclock secs ( 9.59 usr 1.60 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for min_max (60): 25 wallclock secs ( 0.22 usr 0.03 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for count_on_key (100): 37 wallclock secs ( 0.33 usr 0.04 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for count (100): 51 wallclock secs ( 0.30 usr 0.04 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing update with functions
+Time for update_key (500): 220 wallclock secs ( 0.76 usr 0.07 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for update_key_big (501): 429 wallclock secs ( 0.83 usr 0.20 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing delete
+Time for delete_key (500): 628 wallclock secs ( 0.70 usr 0.16 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for delete_big (12): 399 wallclock secs ( 0.09 usr 0.17 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Insert into table with 16 keys and with a primary key with 15 parts
+Time for insert_key (100000): 1293 wallclock secs (151.81 usr 16.58 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing update of keys
+Time for update_of_key (256): 568 wallclock secs ( 0.30 usr 0.06 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Deleting everything from table
+Time for delete_big (2): 378 wallclock secs ( 0.00 usr 0.01 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Estimated total time: 114468 wallclock secs (3850.94 usr 602.34 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/insert-solid_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/insert-solid_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..191e9b11934 --- /dev/null +++ b/sql-bench/Results-win32/insert-solid_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,102 @@ +Testing server 'Solid version ???' at 1998-10-23 9:11:17 + +Testing the speed of inserting data into 1 table and do some selects on it. +The tests are done with a table that has 100000 rows. + +Generating random keys +Creating tables +Inserting 100000 rows in order +0 : Fri Oct 23 09:11:20 1998 +10000 : Fri Oct 23 09:12:05 1998 +20000 : Fri Oct 23 09:12:51 1998 +30000 : Fri Oct 23 09:13:38 1998 +40000 : Fri Oct 23 09:14:25 1998 +50000 : Fri Oct 23 09:15:13 1998 +60000 : Fri Oct 23 09:16:01 1998 +70000 : Fri Oct 23 09:16:49 1998 +80000 : Fri Oct 23 09:17:37 1998 +90000 : Fri Oct 23 09:18:25 1998 +Inserting 100000 rows in reverse order +0 : Fri Oct 23 09:19:14 1998 +10000 : Fri Oct 23 09:20:02 1998 +20000 : Fri Oct 23 09:20:49 1998 +30000 : Fri Oct 23 09:21:36 1998 +40000 : Fri Oct 23 09:22:23 1998 +50000 : Fri Oct 23 09:23:11 1998 +60000 : Fri Oct 23 09:24:00 1998 +70000 : Fri Oct 23 09:24:48 1998 +80000 : Fri Oct 23 09:25:37 1998 +90000 : Fri Oct 23 09:26:25 1998 +Inserting 100000 rows in random order +0 : Fri Oct 23 09:27:13 1998 +10000 : Fri Oct 23 09:28:01 1998 +20000 : Fri Oct 23 09:28:50 1998 +30000 : Fri Oct 23 09:29:39 1998 +40000 : Fri Oct 23 09:30:30 1998 +50000 : Fri Oct 23 09:31:21 1998 +60000 : Fri Oct 23 09:32:13 1998 +70000 : Fri Oct 23 09:33:06 1998 +80000 : Fri Oct 23 09:34:00 1998 +90000 : Fri Oct 23 09:34:55 1998 +Time for insert (300000): 1468 secs (1468.33 usr 0.00 sys = 1468.33 cpu) + +Testing insert of duplicates +Time for insert_duplicates (300000): 172 secs (172.25 usr 0.00 sys = 172.25 cpu) + +Retrieving data from the table +Time for select_big (10:3000000): 589 secs (588.93 usr 0.00 sys = 588.93 cpu) +Time for order_by_key (10:3000000): 653 secs (653.06 usr 0.00 sys = 653.06 cpu) +Time for order_by (10:3000000): 648 secs (647.94 usr 0.00 sys = 647.94 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +140 queries in 140 loops of 5000 loops took 614 seconds +Estimated time for select_range_prefix (5000:560): 21928 secs (21912.93 usr 0.00 sys = 21912.93 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +140 queries in 140 loops of 5000 loops took 617 seconds +Estimated time for select_range (5000:560): 22035 secs (22045.64 usr 0.00 sys = 22045.64 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +142458 queries in 71229 loops of 100000 loops took 601 seconds +Estimated time for select_key_prefix (200000): 843 secs (842.99 usr 0.00 sys = 842.99 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +136926 queries in 68463 loops of 100000 loops took 601 seconds +Estimated time for select_key (200000): 877 secs (877.85 usr 0.00 sys = 877.85 cpu) + +Test of compares with simple ranges +Note: Query took longer then time-limit: 600 +Estimating end time based on: +360 queries in 9 loops of 500 loops took 620 seconds +Estimated time for select_range_prefix (20000:783): 620 secs (620.05 usr 0.00 sys = 620.05 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +360 queries in 9 loops of 500 loops took 622 seconds +Estimated time for select_range (20000:783): 622 secs (622.63 usr 0.00 sys = 622.63 cpu) +Time for select_group (91): 2495 secs (2494.69 usr 0.00 sys = 2494.69 cpu) +Time for min_max_on_key (3000): 13 secs (13.34 usr 0.00 sys = 13.34 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +54 queries in 9 loops of 500 loops took 655 seconds +Estimated time for min_max (3000): 36388 secs (36350.61 usr 0.00 sys = 36350.61 cpu) +Time for count_on_key (100): 2139 secs (2139.16 usr 0.00 sys = 2139.16 cpu) +Time for count (100): 2221 secs (2220.87 usr 0.00 sys = 2220.87 cpu) + +Testing update with functions +Time for update_key (500): 2 secs ( 2.71 usr 0.00 sys = 2.71 cpu) +Time for update_key_big (501): 994 secs (993.63 usr 0.00 sys = 993.63 cpu) + +Testing delete +Time for delete_key (500): 65 secs (65.34 usr 0.00 sys = 65.34 cpu) +Time for delete_big (12): 492 secs (491.75 usr 0.00 sys = 491.75 cpu) + +Insert into table with 16 keys and with a primary key with 15 parts +Time for insert_key (100000): 9758 secs (9757.93 usr 0.00 sys = 9757.93 cpu) + +Testing update of keys +Time for update_of_key (256): 16656 secs (16655.63 usr 0.00 sys = 16655.63 cpu) + +Deleting everything from table +Time for delete_big (2): 1736 secs (1735.77 usr 0.00 sys = 1735.77 cpu) + +Estimated total time: 192155 secs (192149.60 usr 0.00 sys = 192149.60 cpu) diff --git a/sql-bench/Results-win32/insert-sybase_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/insert-sybase_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..b5cd78f3c4a --- /dev/null +++ b/sql-bench/Results-win32/insert-sybase_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,99 @@ +Testing server 'Sybase enterprise 11.5 NT' at 1998-10-02 8:13:25 + +Testing the speed of inserting data into 1 table and do some selects on it. +The tests are done with a table that has 100000 rows. + +Generating random keys +Creating tables +Inserting 100000 rows in order +0 : Fri Oct 2 08:13:31 1998 +10000 : Fri Oct 2 08:15:49 1998 +20000 : Fri Oct 2 08:18:01 1998 +30000 : Fri Oct 2 08:20:14 1998 +40000 : Fri Oct 2 08:22:27 1998 +50000 : Fri Oct 2 08:24:48 1998 +60000 : Fri Oct 2 08:27:19 1998 +70000 : Fri Oct 2 08:30:03 1998 +80000 : Fri Oct 2 08:32:09 1998 +90000 : Fri Oct 2 08:34:12 1998 +Inserting 100000 rows in reverse order +0 : Fri Oct 2 08:36:14 1998 +10000 : Fri Oct 2 08:38:17 1998 +20000 : Fri Oct 2 08:40:22 1998 +30000 : Fri Oct 2 08:42:31 1998 +40000 : Fri Oct 2 08:44:39 1998 +50000 : Fri Oct 2 08:46:43 1998 +60000 : Fri Oct 2 08:48:50 1998 +70000 : Fri Oct 2 08:51:04 1998 +80000 : Fri Oct 2 08:53:26 1998 +90000 : Fri Oct 2 08:56:23 1998 +Inserting 100000 rows in random order +0 : Fri Oct 2 08:58:39 1998 +10000 : Fri Oct 2 09:01:03 1998 +20000 : Fri Oct 2 09:04:49 1998 +30000 : Fri Oct 2 09:08:33 1998 +40000 : Fri Oct 2 09:12:29 1998 +50000 : Fri Oct 2 09:15:12 1998 +60000 : Fri Oct 2 09:18:09 1998 +70000 : Fri Oct 2 09:21:29 1998 +80000 : Fri Oct 2 09:24:42 1998 +90000 : Fri Oct 2 09:28:39 1998 +Time for insert (300000): 4682 secs (4681.62 usr 0.00 sys = 4681.62 cpu) + +Testing insert of duplicates +Time for insert_duplicates (300000): 331 secs (331.28 usr 0.00 sys = 331.28 cpu) + +Retrieving data from the table +Time for select_big (10:3000000): 275 secs (275.20 usr 0.00 sys = 275.20 cpu) +Time for order_by_key (10:3000000): 273 secs (272.97 usr 0.00 sys = 272.97 cpu) +Time for order_by (10:3000000): 395 secs (394.89 usr 0.00 sys = 394.89 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +1490 queries in 1490 loops of 5000 loops took 601 seconds +Estimated time for select_range_prefix (5000:5960): 2016 secs (2017.70 usr 0.00 sys = 2017.70 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +1490 queries in 1490 loops of 5000 loops took 603 seconds +Estimated time for select_range (5000:5960): 2023 secs (2021.03 usr 0.00 sys = 2021.03 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +6904 queries in 3452 loops of 100000 loops took 601 seconds +Estimated time for select_key_prefix (200000): 17410 secs (17410.02 usr 0.00 sys = 17410.02 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +6824 queries in 3412 loops of 100000 loops took 601 seconds +Estimated time for select_key (200000): 17614 secs (17614.13 usr 0.00 sys = 17614.13 cpu) + +Test of compares with simple ranges +Note: Query took longer then time-limit: 600 +Estimating end time based on: +2920 queries in 73 loops of 500 loops took 602 seconds +Estimated time for select_range_prefix (20000:6351): 602 secs (602.38 usr 0.00 sys = 602.38 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +2920 queries in 73 loops of 500 loops took 603 seconds +Estimated time for select_range (20000:6351): 603 secs (603.08 usr 0.00 sys = 603.08 cpu) +Time for select_group (91): 56 secs (55.88 usr 0.00 sys = 55.88 cpu) +Time for min_max_on_key (3000): 96 secs (96.64 usr 0.00 sys = 96.64 cpu) +Time for min_max (60): 17 secs (16.74 usr 0.00 sys = 16.74 cpu) +Time for count_on_key (100): 14 secs (14.21 usr 0.00 sys = 14.21 cpu) +Time for count (100): 23 secs (22.40 usr 0.00 sys = 22.40 cpu) + +Testing update with functions +Time for update_key (500): 40 secs (39.90 usr 0.00 sys = 39.90 cpu) +Time for update_key_big (501): 347 secs (347.05 usr 0.00 sys = 347.05 cpu) + +Testing delete +Time for delete_key (500): 43 secs (42.44 usr 0.00 sys = 42.44 cpu) +Time for delete_big (12): 181 secs (181.45 usr 0.00 sys = 181.45 cpu) + +Insert into table with 16 keys and with a primary key with 15 parts +Time for insert_key (100000): 7053 secs (7053.03 usr 0.00 sys = 7053.03 cpu) + +Testing update of keys +Time for update_of_key (256): 1023 secs (1022.68 usr 0.00 sys = 1022.68 cpu) + +Deleting everything from table +Time for delete_big (2): 7736 secs (7735.26 usr 0.00 sys = 7735.26 cpu) + +Estimated total time: 69907 secs (69908.40 usr 0.00 sys = 69908.40 cpu) diff --git a/sql-bench/Results-win32/select-access_odbc-win98-cmp-access,mysql b/sql-bench/Results-win32/select-access_odbc-win98-cmp-access,mysql new file mode 100644 index 00000000000..b51c2999152 --- /dev/null +++ b/sql-bench/Results-win32/select-access_odbc-win98-cmp-access,mysql @@ -0,0 +1,19 @@ +Testing server 'Access 2000' at 2000-01-04 0:50:34
+
+Testing the speed of selecting on keys that consist of many parts
+The test-table has 10000 rows and the test is done with 45.5 ranges.
+
+Creating table
+Inserting 10000 rows
+Time to insert (10000): 69 wallclock secs (68.33 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing big selects on the table
+Time for select_big (70:17207): 4 wallclock secs ( 3.96 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_range (410:248587): 63 wallclock secs (63.11 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Note: Query took longer then time-limit: 600
+Estimating end time based on:
+37233 queries in 5319 loops of 10000 loops took 601 seconds
+Estimated time for min_max_on_key (70000): 1129 wallclock secs (1129.48 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for count_on_key (50000): 445 wallclock secs (445.17 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Estimated total time: 1710 wallclock secs (1710.98 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/select-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/select-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..7408c75b6a6 --- /dev/null +++ b/sql-bench/Results-win32/select-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,22 @@ +Testing server 'IBM DB2 5' at 1999-02-02 3:47:34 + +Testing the speed of selecting on keys that consist of many parts +The test-table has 10000 rows and the test is done with 8.5 ranges. + +Creating table +Inserting 10000 rows +Time to insert (10000): 97 secs (97.40 usr 0.00 sys = 97.40 cpu) + +Testing big selects on the table +Time for select_big (70:17207): 4 secs ( 3.28 usr 0.00 sys = 3.28 cpu) +Time for select_range (400:61130): 24 secs (23.86 usr 0.00 sys = 23.86 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +39872 queries in 5696 loops of 10000 loops took 601 seconds +Estimated time for min_max_on_key (70000): 1055 secs (1055.01 usr 0.00 sys = 1055.01 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +39885 queries in 7977 loops of 10000 loops took 601 seconds +Estimated time for count_key (50000): 753 secs (753.46 usr 0.00 sys = 753.46 cpu) + +Estimated total time: 1934 secs (1934.67 usr 0.00 sys = 1934.67 cpu) diff --git a/sql-bench/Results-win32/select-informix_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/select-informix_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..f3c45dd6258 --- /dev/null +++ b/sql-bench/Results-win32/select-informix_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,19 @@ +Testing server 'Informix 7.30C1 ' at 1998-10-06 1:41:01 + +Testing the speed of selecting on keys that consist of many parts +The test-table has 10000 rows and the test is done with 8.5 ranges. + +Creating table +Inserting 10000 rows +Time to insert (10000): 51 secs (51.92 usr 0.00 sys = 51.92 cpu) + +Testing big selects on the table +Time for select_big (70:17207): 12 secs (11.92 usr 0.00 sys = 11.92 cpu) +Time for select_range (400:61130): 29 secs (28.45 usr 0.00 sys = 28.45 cpu) +Time for min_max_on_key (70000): 475 secs (474.89 usr 0.00 sys = 474.89 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +3840 queries in 768 loops of 10000 loops took 601 seconds +Estimated time for count_key (50000): 7825 secs (7824.40 usr 0.00 sys = 7824.40 cpu) + +Estimated total time: 8393 secs (8391.74 usr 0.00 sys = 8391.74 cpu) diff --git a/sql-bench/Results-win32/select-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/select-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..4475ad4572c --- /dev/null +++ b/sql-bench/Results-win32/select-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,19 @@ +Testing server 'Microsoft SQL Server 7.00 - 7.00.517 (Intel X86) ' at 1998-09-07 14:22:16 + +Testing the speed of selecting on keys that consist of many parts +The test-table has 10000 rows and the test is done with 8.5 ranges. + +Creating table +Inserting 10000 rows +Time to insert (10000): 93 secs (93.21 usr 0.00 sys = 93.21 cpu) + +Testing big selects on the table +Time for select_big (70:17207): 2 secs ( 2.32 usr 0.00 sys = 2.32 cpu) +Time for select_range (400:61130): 19 secs (18.64 usr 0.00 sys = 18.64 cpu) +Time for min_max_on_key (70000): 308 secs (308.18 usr 0.00 sys = 308.18 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +39370 queries in 7874 loops of 10000 loops took 601 seconds +Estimated time for count_key (50000): 763 secs (762.84 usr 0.00 sys = 762.84 cpu) + +Estimated total time: 1186 secs (1185.72 usr 0.00 sys = 1185.72 cpu) diff --git a/sql-bench/Results-win32/select-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/select-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..e41c1620a2c --- /dev/null +++ b/sql-bench/Results-win32/select-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,19 @@ +Testing server 'MySQL 3.22.16 gamma' at 1999-02-20 21:28:50 + +Testing the speed of selecting on keys that consist of many parts +The test-table has 10000 rows and the test is done with 8.5 ranges. + +Creating table +Inserting 10000 rows +Time to insert (10000): 12 wallclock secs ( 2.52 usr + 1.26 sys = 3.79 CPU) + +Testing big selects on the table +Time for select_big (70:17207): 1 wallclock secs ( 0.23 usr + 0.11 sys = 0.34 CPU) +Time for select_range (400:61130): 5 wallclock secs ( 1.21 usr + 0.42 sys = 1.63 CPU) +Time for min_max_on_key (70000): 216 wallclock secs (49.80 usr + 13.51 sys = 63.31 CPU) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +45135 queries in 9027 loops of 10000 loops took 601 seconds +Estimated time for count_key (50000): 665 wallclock secs (36.67 usr + 9.66 sys = 46.33 CPU) + +Estimated total time: 899 wallclock secs (90.43 usr + 24.97 sys = 115.41 CPU) diff --git a/sql-bench/Results-win32/select-mysql-win98 b/sql-bench/Results-win32/select-mysql-win98 new file mode 100644 index 00000000000..c028aaf9661 --- /dev/null +++ b/sql-bench/Results-win32/select-mysql-win98 @@ -0,0 +1,16 @@ +Testing server 'MySQL 3.23.13a alpha' at 2000-03-15 5:20:12
+
+Testing the speed of selecting on keys that consist of many parts
+The test-table has 10000 rows and the test is done with 500 ranges.
+
+Creating table
+Inserting 10000 rows
+Time to insert (10000): 16 wallclock secs (15.32 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing big selects on the table
+Time for select_big (70:17207): 1 wallclock secs ( 1.81 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_range (410:1057904): 356 wallclock secs (356.09 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for min_max_on_key (70000): 332 wallclock secs (332.69 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for count_on_key (50000): 588 wallclock secs (587.48 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Total time: 1294 wallclock secs (1293.83 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/select-mysql-win98-cmp-access,mysql b/sql-bench/Results-win32/select-mysql-win98-cmp-access,mysql new file mode 100644 index 00000000000..3607cb4d07e --- /dev/null +++ b/sql-bench/Results-win32/select-mysql-win98-cmp-access,mysql @@ -0,0 +1,19 @@ +Testing server 'MySQL 3.23.8 alpha' at 2000-01-04 13:37:12
+
+Testing the speed of selecting on keys that consist of many parts
+The test-table has 10000 rows and the test is done with 40 ranges.
+
+Creating table
+Inserting 10000 rows
+Time to insert (10000): 19 wallclock secs (19.39 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing big selects on the table
+Time for select_big (70:17207): 2 wallclock secs ( 1.97 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_range (410:214316): 37 wallclock secs (36.36 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for min_max_on_key (70000): 352 wallclock secs (352.24 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Note: Query took longer then time-limit: 600
+Estimating end time based on:
+46695 queries in 9339 loops of 10000 loops took 601 seconds
+Estimated time for count_on_key (50000): 643 wallclock secs (643.18 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Estimated total time: 1053 wallclock secs (1053.14 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/select-mysql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/select-mysql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..64e97b34913 --- /dev/null +++ b/sql-bench/Results-win32/select-mysql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,19 @@ +Testing server 'MySQL 3.22.16 gamma' at 1999-02-07 13:47:07 + +Testing the speed of selecting on keys that consist of many parts +The test-table has 10000 rows and the test is done with 8.5 ranges. + +Creating table +Inserting 10000 rows +Time to insert (10000): 18 secs (17.89 usr 0.00 sys = 17.89 cpu) + +Testing big selects on the table +Time for select_big (70:17207): 3 secs ( 2.81 usr 0.00 sys = 2.81 cpu) +Time for select_range (400:61130): 12 secs (11.82 usr 0.00 sys = 11.82 cpu) +Time for min_max_on_key (70000): 261 secs (261.04 usr 0.00 sys = 261.04 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +42345 queries in 8469 loops of 10000 loops took 601 seconds +Estimated time for count_key (50000): 709 secs (709.52 usr 0.00 sys = 709.52 cpu) + +Estimated total time: 1003 secs (1003.10 usr 0.00 sys = 1003.10 cpu) diff --git a/sql-bench/Results-win32/select-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/select-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..fd7f03a54a6 --- /dev/null +++ b/sql-bench/Results-win32/select-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,22 @@ +Testing server 'Oracle 8.0.4.0.0' at 1999-04-04 7:11:38
+
+Testing the speed of selecting on keys that consist of many parts
+The test-table has 10000 rows and the test is done with 8.5 ranges.
+
+Creating table
+Inserting 10000 rows
+Time to insert (10000): 81 wallclock secs (13.55 usr 1.50 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Testing big selects on the table
+Time for select_big (70:17207): 9 wallclock secs ( 3.35 usr 0.54 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time for select_range (400:61130): 53 wallclock secs (14.24 usr 1.92 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Note: Query took longer then time-limit: 600
+Estimating end time based on:
+36078 queries in 5154 loops of 10000 loops took 601 seconds
+Estimated time for min_max_on_key (70000): 1166 wallclock secs (155.66 usr 33.79 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Note: Query took longer then time-limit: 600
+Estimating end time based on:
+36075 queries in 7215 loops of 10000 loops took 601 seconds
+Estimated time for count_on_key (50000): 832 wallclock secs (118.15 usr 25.25 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Estimated total time: 2147 wallclock secs (304.96 usr 63.03 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/select-solid_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/select-solid_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..2a83ce0e6ad --- /dev/null +++ b/sql-bench/Results-win32/select-solid_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,22 @@ +Testing server 'Solid version ???' at 1998-10-08 16:21:29 + +Testing the speed of selecting on keys that consist of many parts +The test-table has 10000 rows and the test is done with 8.5 ranges. + +Creating table +Inserting 10000 rows +Time to insert (10000): 55 secs (55.66 usr 0.00 sys = 55.66 cpu) + +Testing big selects on the table +Time for select_big (70:17207): 5 secs ( 5.04 usr 0.00 sys = 5.04 cpu) +Time for select_range (400:61800): 106 secs (105.79 usr 0.00 sys = 105.79 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +3661 queries in 523 loops of 10000 loops took 601 seconds +Estimated time for min_max_on_key (70000): 11491 secs (11490.52 usr 0.00 sys = 11490.52 cpu) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +1785 queries in 357 loops of 10000 loops took 602 seconds +Estimated time for count_key (50000): 16862 secs (16847.20 usr 0.00 sys = 16847.20 cpu) + +Estimated total time: 28523 secs (28507.76 usr 0.00 sys = 28507.76 cpu) diff --git a/sql-bench/Results-win32/wisconsin-access_odbc-win98-cmp-access,mysql b/sql-bench/Results-win32/wisconsin-access_odbc-win98-cmp-access,mysql new file mode 100644 index 00000000000..bc3161800aa --- /dev/null +++ b/sql-bench/Results-win32/wisconsin-access_odbc-win98-cmp-access,mysql @@ -0,0 +1,14 @@ +Testing server 'Access 2000' at 2000-01-04 1:10:19
+
+Wisconsin benchmark test
+
+Time for create_table (3): 1 wallclock secs ( 0.17 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Inserting data
+Time to insert (31000): 246 wallclock secs (246.83 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time to delete_big (1): 2 wallclock secs ( 1.32 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Running actual benchmark
+Time for wisc_benchmark (114): 33 wallclock secs (33.17 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Total time: 282 wallclock secs (281.60 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/wisconsin-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/wisconsin-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..12e5cc45966 --- /dev/null +++ b/sql-bench/Results-win32/wisconsin-db2_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,14 @@ +Testing server 'IBM DB2 5' at 1999-02-02 4:09:47 + +Wisconsin benchmark test + +Time for create_table (3): 3 secs ( 3.03 usr 0.00 sys = 3.03 cpu) + +Inserting data +Time to insert (31000): 330 secs (329.62 usr 0.00 sys = 329.62 cpu) +Time to delete_big (1): 2 secs ( 1.86 usr 0.00 sys = 1.86 cpu) + +Running actual benchmark +Time for wisc_benchmark (114): 32 secs (32.10 usr 0.00 sys = 32.10 cpu) + +Total time: 368 secs (367.48 usr 0.00 sys = 367.48 cpu) diff --git a/sql-bench/Results-win32/wisconsin-informix_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/wisconsin-informix_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..b05d8a1472e --- /dev/null +++ b/sql-bench/Results-win32/wisconsin-informix_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,14 @@ +Testing server 'Informix 7.30C1 ' at 1998-10-06 2:00:31 + +Wisconsin benchmark test + +Time for create_table (3): 0 secs ( 0.25 usr 0.00 sys = 0.25 cpu) + +Inserting data +Time to insert (31000): 171 secs (170.83 usr 0.00 sys = 170.83 cpu) +Time to delete_big (1): 2 secs ( 2.36 usr 0.00 sys = 2.36 cpu) + +Running actual benchmark +Time for wisc_benchmark (114): 45 secs (44.91 usr 0.00 sys = 44.91 cpu) + +Total time: 219 secs (219.03 usr 0.00 sys = 219.03 cpu) diff --git a/sql-bench/Results-win32/wisconsin-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/wisconsin-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..79a4c199124 --- /dev/null +++ b/sql-bench/Results-win32/wisconsin-ms-sql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,14 @@ +Testing server 'Microsoft SQL Server 7.00 - 7.00.517 (Intel X86) ' at 1998-09-07 14:39:20 + +Wisconsin benchmark test + +Time for create_table (3): 0 secs ( 0.61 usr 0.00 sys = 0.61 cpu) + +Inserting data +Time to insert (31000): 262 secs (261.70 usr 0.00 sys = 261.70 cpu) +Time to delete_big (1): 4 secs ( 3.98 usr 0.00 sys = 3.98 cpu) + +Running actual benchmark +Time for wisc_benchmark (114): 24 secs (23.97 usr 0.00 sys = 23.97 cpu) + +Total time: 290 secs (290.80 usr 0.00 sys = 290.80 cpu) diff --git a/sql-bench/Results-win32/wisconsin-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/wisconsin-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..194401cb8f7 --- /dev/null +++ b/sql-bench/Results-win32/wisconsin-mysql-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,14 @@ +Testing server 'MySQL 3.22.16 gamma' at 1999-02-20 21:42:45 + +Wisconsin benchmark test + +Time for create_table (3): 0 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) + +Inserting data +Time to insert (31000): 29 wallclock secs ( 4.75 usr + 3.96 sys = 8.70 CPU) +Time to delete_big (1): 1 wallclock secs ( 0.00 usr + 0.00 sys = 0.00 CPU) + +Running actual benchmark +Time for wisc_benchmark (114): 8 wallclock secs ( 3.07 usr + 1.29 sys = 4.37 CPU) + +Total time: 38 wallclock secs ( 7.83 usr + 5.25 sys = 13.08 CPU) diff --git a/sql-bench/Results-win32/wisconsin-mysql-win98 b/sql-bench/Results-win32/wisconsin-mysql-win98 new file mode 100644 index 00000000000..71bb6b4f3de --- /dev/null +++ b/sql-bench/Results-win32/wisconsin-mysql-win98 @@ -0,0 +1,14 @@ +Testing server 'MySQL 3.23.13a alpha' at 2000-03-15 5:41:46
+
+Wisconsin benchmark test
+
+Time for create_table (3): 1 wallclock secs ( 0.99 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Inserting data
+Time to insert (31000): 44 wallclock secs (43.67 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time to delete_big (1): 1 wallclock secs ( 0.66 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Running actual benchmark
+Time for wisc_benchmark (114): 17 wallclock secs (17.08 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Total time: 63 wallclock secs (62.40 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/wisconsin-mysql-win98-cmp-access,mysql b/sql-bench/Results-win32/wisconsin-mysql-win98-cmp-access,mysql new file mode 100644 index 00000000000..0acaf169c1a --- /dev/null +++ b/sql-bench/Results-win32/wisconsin-mysql-win98-cmp-access,mysql @@ -0,0 +1,14 @@ +Testing server 'MySQL 3.23.8 alpha' at 2000-01-04 13:54:03
+
+Wisconsin benchmark test
+
+Time for create_table (3): 0 wallclock secs ( 0.11 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Inserting data
+Time to insert (31000): 49 wallclock secs (48.88 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time to delete_big (1): 1 wallclock secs ( 0.66 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Running actual benchmark
+Time for wisc_benchmark (114): 18 wallclock secs (18.67 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Total time: 68 wallclock secs (68.32 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/wisconsin-mysql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/wisconsin-mysql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..b064bc0d04b --- /dev/null +++ b/sql-bench/Results-win32/wisconsin-mysql_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,14 @@ +Testing server 'MySQL 3.22.16 gamma' at 1999-02-07 14:02:02 + +Wisconsin benchmark test + +Time for create_table (3): 0 secs ( 0.05 usr 0.00 sys = 0.05 cpu) + +Inserting data +Time to insert (31000): 50 secs (50.09 usr 0.00 sys = 50.09 cpu) +Time to delete_big (1): 1 secs ( 0.45 usr 0.00 sys = 0.45 cpu) + +Running actual benchmark +Time for wisc_benchmark (114): 23 secs (23.44 usr 0.00 sys = 23.44 cpu) + +Total time: 74 secs (74.07 usr 0.00 sys = 74.07 cpu) diff --git a/sql-bench/Results-win32/wisconsin-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/wisconsin-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..252c484443a --- /dev/null +++ b/sql-bench/Results-win32/wisconsin-oracle_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,14 @@ +Testing server 'Oracle 8.0.4.0.0' at 1999-04-04 7:34:35
+
+Wisconsin benchmark test
+
+Time for create_table (3): 0 wallclock secs ( 0.01 usr 0.01 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Inserting data
+Time to insert (31000): 245 wallclock secs (41.80 usr 5.20 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+Time to delete_big (1): 7 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Running actual benchmark
+Time for wisc_benchmark (114): 82 wallclock secs (44.61 usr 5.10 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
+
+Total time: 335 wallclock secs (86.43 usr 10.31 sys + 0.00 cusr 0.00 csys = 0.00 CPU)
diff --git a/sql-bench/Results-win32/wisconsin-solid_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase b/sql-bench/Results-win32/wisconsin-solid_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase new file mode 100644 index 00000000000..8b953a2933d --- /dev/null +++ b/sql-bench/Results-win32/wisconsin-solid_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase @@ -0,0 +1,14 @@ +Testing server 'Solid version ???' at 1998-10-08 16:44:23 + +Wisconsin benchmark test + +Time for create_table (3): 0 secs ( 0.20 usr 0.00 sys = 0.20 cpu) + +Inserting data +Time to insert (31000): 233 secs (232.63 usr 0.00 sys = 232.63 cpu) +Time to delete_big (1): 8 secs ( 8.24 usr 0.00 sys = 8.24 cpu) + +Running actual benchmark +Time for wisc_benchmark (114): 84 secs (83.66 usr 0.00 sys = 83.66 cpu) + +Total time: 338 secs (338.33 usr 0.00 sys = 338.33 cpu) |