diff options
Diffstat (limited to 'sql-bench/Results/insert-oracle_fast-Linux_2.0.36_i686-cmp-mysql,oracle')
| -rw-r--r-- | sql-bench/Results/insert-oracle_fast-Linux_2.0.36_i686-cmp-mysql,oracle | 101 |
1 files changed, 101 insertions, 0 deletions
diff --git a/sql-bench/Results/insert-oracle_fast-Linux_2.0.36_i686-cmp-mysql,oracle b/sql-bench/Results/insert-oracle_fast-Linux_2.0.36_i686-cmp-mysql,oracle new file mode 100644 index 00000000000..8e691054811 --- /dev/null +++ b/sql-bench/Results/insert-oracle_fast-Linux_2.0.36_i686-cmp-mysql,oracle @@ -0,0 +1,101 @@ +Testing server 'Oracle 8.0.5.0.0' at 1999-03-23 8:24: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 +Time for book-keeping (1): 0 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) + +Inserting 100000 rows in order +Inserting 100000 rows in reverse order +Inserting 100000 rows in random order +Time for insert (300000): 1154 wallclock secs (221.85 usr 27.98 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) + +Time for book-keeping (1): 14 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) + +Testing insert of duplicates +Time for insert_duplicates (300000): 2001 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) + +Time for book-keeping (1): 11 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) + +Retrieving data from the table +Time for select_big (10:3000000): 855 wallclock secs (366.27 usr 95.53 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +8 queries in 8 loops of 10 loops took 685 seconds +Estimated time for order_by_key (10:2400000): 856 wallclock secs (370.12 usr 85.01 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) +Time for book-keeping (1): 12 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) + +Note: Query took longer then time-limit: 600 +Estimating end time based on: +8 queries in 8 loops of 10 loops took 646 seconds +Estimated time for order_by (10:2400000): 807 wallclock secs (349.92 usr 85.42 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) +Time for book-keeping (1): 11 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) + +Time for select_range_prefix (5010:42084): 47 wallclock secs (18.29 usr 3.52 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +225 queries in 225 loops of 5000 loops took 639 seconds +Estimated time for select_range (5000:1890): 14200 wallclock secs (18.89 usr 2.67 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +159614 queries in 79807 loops of 100000 loops took 601 seconds +Estimated time for select_key_prefix (200000): 753 wallclock secs (235.02 usr 39.45 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) +Note: Query took longer then time-limit: 600 +Estimating end time based on: +1312 queries in 656 loops of 100000 loops took 601 seconds +Estimated time for select_key (200000): 91615 wallclock secs (228.66 usr 33.54 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) +Time for book-keeping (1): 12 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) + + +Test of compares with simple ranges +Time for select_range_prefix (20000:43500): 37 wallclock secs (17.15 usr 3.23 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) +Time for book-keeping (1): 11 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) + +Note: Query took longer then time-limit: 600 +Estimating end time based on: +1480 queries in 37 loops of 500 loops took 615 seconds +Estimated time for select_range (20000:3219): 615 wallclock secs ( 1.24 usr 0.17 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) +Time for book-keeping (1): 11 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) + +Time for select_group (91): 53 wallclock secs ( 0.08 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) +Time for min_max_on_key (3000): 9 wallclock secs ( 3.39 usr 0.70 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) +Time for min_max (60): 25 wallclock secs ( 0.09 usr 0.02 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) +Time for count_on_key (100): 35 wallclock secs ( 0.11 usr 0.01 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) +Time for count (100): 50 wallclock secs ( 0.10 usr 0.04 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) + +Testing update with functions +Time for update_key (500): 223 wallclock secs ( 0.31 usr 0.02 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) +Time for book-keeping (1): 11 wallclock secs ( 0.01 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) + +Time for update_key_big (501): 302 wallclock secs ( 0.45 usr 0.10 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) + +Time for book-keeping (1): 29 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) + +Testing delete +Time for delete_key (500): 262 wallclock secs ( 0.31 usr 0.03 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) +Time for book-keeping (1): 11 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) + +Time for delete_big (12): 500 wallclock secs ( 0.03 usr 0.05 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) + +Time for book-keeping (1): 0 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) + +Insert into table with 16 keys and with a primary key with 16 parts +Time for book-keeping (1): 0 wallclock secs ( 0.01 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) + +Time for insert_key (100000): 677 wallclock secs (78.14 usr 9.36 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) + +Time for book-keeping (1): 24 wallclock secs ( 0.01 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) + +Testing update of keys +Time for update_of_key (256): 601 wallclock secs ( 0.18 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) + +Time for book-keeping (1): 111 wallclock secs ( 0.01 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) + +Deleting everything from table +Time for delete_big (2): 969 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) + +Time for book-keeping (1): 0 wallclock secs ( 0.00 usr 0.00 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) + +Estimated total time: 124637 wallclock secs (1926.54 usr 389.27 sys + 0.00 cusr 0.00 csys = 0.00 CPU secs) |