blob: b5cd78f3c4a919d0e3c2126432743ff6c240c857 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
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)
|
