insert-sybase_odbc-NT_4.0-cmp-db2,informix,ms-sql,mysql,oracle,solid,sybase
上传用户:tsgydb
上传日期:2007-04-14
资源大小:10674k
文件大小:4k
源码类别:
MySQL数据库
开发平台:
Visual C++
- 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)