diff options
Diffstat (limited to 'sql-bench/Results-win32/insert-sybase_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase')
| -rw-r--r-- | sql-bench/Results-win32/insert-sybase_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase | 99 |
1 files changed, 99 insertions, 0 deletions
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) |