insert-sybase_odbc-nt_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase

开启mysql的远程连接的方法 mysql-noinstall-5.1.6-alpha-win32.zip

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)