diff options
Diffstat (limited to 'sql-bench/Results/RUN-oracle_fast-Linux_2.0.36_i686-cmp-mysql,oracle')
| -rw-r--r-- | sql-bench/Results/RUN-oracle_fast-Linux_2.0.36_i686-cmp-mysql,oracle | 57 |
1 files changed, 57 insertions, 0 deletions
diff --git a/sql-bench/Results/RUN-oracle_fast-Linux_2.0.36_i686-cmp-mysql,oracle b/sql-bench/Results/RUN-oracle_fast-Linux_2.0.36_i686-cmp-mysql,oracle new file mode 100644 index 00000000000..572ddd0e3b0 --- /dev/null +++ b/sql-bench/Results/RUN-oracle_fast-Linux_2.0.36_i686-cmp-mysql,oracle @@ -0,0 +1,57 @@ +Benchmark DBD suite: 2.0b +Date of test: 1999-03-23 8:05:45 +Running tests on: Linux 2.0.36 i686 +Arguments: --force --fast +Comments: +Limits from: mysql,oracle +Server version: Oracle 8.0.5.0.0 + +ATIS: Total time: 396 wallclock secs (124.50 usr 29.24 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) +alter-table: Total time: 13 wallclock secs ( 1.14 usr 0.11 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) +big-tables: Total time: 49 wallclock secs (12.68 usr 0.78 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) +connect: Total time: 49 wallclock secs (12.68 usr 0.78 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) +create: Total time: 611 wallclock secs (11.43 usr 1.28 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) +insert: Estimated total time: 124637 wallclock secs (1926.54 usr 389.27 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) +select: Estimated total time: 2285 wallclock secs (259.15 usr 54.33 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) +wisconsin: Total time: 190 wallclock secs (53.06 usr 7.56 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) + +All 8 test executed successfully +Tests with estimated time have a + at end of line + +Totals per operation: +Operation seconds usr sys cpu tests +alter_table_add 8 0.31 0.02 0.00 246 +book-keeping 362 1.79 0.26 0.00 34 +count 50 0.10 0.04 0.00 100 +count_on_key 813 56.44 12.01 0.00 50100 + +create+drop 198 2.72 0.37 0.00 1000 +create_index 0 0.01 0.00 0.00 8 +create_key+drop 174 3.64 0.28 0.00 1000 +create_table 108 1.93 0.18 0.00 1031 +delete_big 1475 0.06 0.06 0.00 15 +delete_key 262 0.31 0.03 0.00 500 +drop_index 1 0.00 0.00 0.00 8 +drop_table 88 0.71 0.04 0.00 1028 +insert 1357 259.88 32.29 0.00 350768 +insert_duplicates 2001 0.00 0.00 0.00 300000 +insert_key 677 78.14 9.36 0.00 100000 +insert_many_fields 7 2.04 0.14 0.00 2000 +min_max 25 0.09 0.02 0.00 60 +min_max_on_key 890 78.61 16.96 0.00 73000 + +order_by 807 349.92 85.42 0.00 10 + +order_by_key 856 370.12 85.01 0.00 10 + +select_big 861 368.26 96.12 0.00 80 +select_distinct 56 24.55 5.45 0.00 800 +select_group 94 13.03 2.94 0.00 3391 +select_join 188 71.78 18.08 0.00 200 +select_key 91615 228.66 33.54 0.00 200000 + +select_key_prefix 753 235.02 39.45 0.00 200000 + +select_many_fields 40 10.55 0.64 0.00 2000 +select_range 15390 137.88 27.54 0.00 25410 ++ +select_range_prefix 84 35.44 6.75 0.00 25010 +select_simple_join 20 8.26 1.90 0.00 500 +update_key 223 0.31 0.02 0.00 500 +update_key_big 302 0.45 0.10 0.00 501 +update_of_key 601 0.18 0.00 0.00 256 +wisc_benchmark 63 30.34 4.90 0.00 114 +TOTALS 120449 2371.53 479.92 0.00 1339680 ++++++++ |