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 ++++++++