А вот если сравнить вставку в индексированные таблицы (БЕЗ дёргания генератора): DDL 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.
100.
101.
102.
103.
104.
105.
106.
107.
108.
set term ^;
execute block as begin
begin
execute statement 'create sequence g;';
when any do begin end
end
end^
set term ;^
commit;
recreate table t01(id int primary key using index t01_pk_idx, x int, y int, z int, u varchar(20), v varchar(20), w varchar(20));
create index t01_zy on t01(z,y);
create index t01_yx on t01(y,x);
create index t01_zx on t01(z,x);
create descending index t01_xy_dec on t01(x,y);
create descending index t01_xz_dec on t01(x,z);
create descending index t01_yz_dec on t01(y,z);
create index t01_uvw_asc on t01(w,v,u);
create descending index t01_uvw_dec on t01(u,v,w);
recreate table t02(id int primary key using index t02_pk_idx, x int, y int, z int, u varchar(20), v varchar(20), w varchar(20));
create index t02_zy on t02(z,y);
create index t02_yx on t02(y,x);
create index t02_zx on t02(z,x);
create descending index t02_xy_dec on t02(x,y);
create descending index t02_xz_dec on t02(x,z);
create descending index t02_yz_dec on t02(y,z);
create index t02_uvw_asc on t02(w,v,u);
create descending index t02_uvw_dec on t02(u,v,w);
recreate table t03(id int primary key using index t03_pk_idx, x int, y int, z int, u varchar(20), v varchar(20), w varchar(20));
create index t03_zy on t03(z,y);
create index t03_yx on t03(y,x);
create index t03_zx on t03(z,x);
create descending index t03_xy_dec on t03(x,y);
create descending index t03_xz_dec on t03(x,z);
create descending index t03_yz_dec on t03(y,z);
create index t03_uvw_asc on t03(w,v,u);
create descending index t03_uvw_dec on t03(u,v,w);
recreate table t04(id int primary key using index t04_pk_idx, x int, y int, z int, u varchar(20), v varchar(20), w varchar(20));
create index t04_zy on t04(z,y);
create index t04_yx on t04(y,x);
create index t04_zx on t04(z,x);
create descending index t04_xy_dec on t04(x,y);
create descending index t04_xz_dec on t04(x,z);
create descending index t04_yz_dec on t04(y,z);
create index t04_uvw_asc on t04(w,v,u);
create descending index t04_uvw_dec on t04(u,v,w);
recreate table t05(id int primary key using index t05_pk_idx, x int, y int, z int, u varchar(20), v varchar(20), w varchar(20));
create index t05_zy on t05(z,y);
create index t05_yx on t05(y,x);
create index t05_zx on t05(z,x);
create descending index t05_xy_dec on t05(x,y);
create descending index t05_xz_dec on t05(x,z);
create descending index t05_yz_dec on t05(y,z);
create index t05_uvw_asc on t05(w,v,u);
create descending index t05_uvw_dec on t05(u,v,w);
recreate table t06(id int primary key using index t06_pk_idx, x int, y int, z int, u varchar(20), v varchar(20), w varchar(20));
create index t06_zy on t06(z,y);
create index t06_yx on t06(y,x);
create index t06_zx on t06(z,x);
create descending index t06_xy_dec on t06(x,y);
create descending index t06_xz_dec on t06(x,z);
create descending index t06_yz_dec on t06(y,z);
create index t06_uvw_asc on t06(w,v,u);
create descending index t06_uvw_dec on t06(u,v,w);
recreate table t07(id int primary key using index t07_pk_idx, x int, y int, z int, u varchar(20), v varchar(20), w varchar(20));
create index t07_zy on t07(z,y);
create index t07_yx on t07(y,x);
create index t07_zx on t07(z,x);
create descending index t07_xy_dec on t07(x,y);
create descending index t07_xz_dec on t07(x,z);
create descending index t07_yz_dec on t07(y,z);
create index t07_uvw_asc on t07(w,v,u);
create descending index t07_uvw_dec on t07(u,v,w);
recreate table t08(id int primary key using index t08_pk_idx, x int, y int, z int, u varchar(20), v varchar(20), w varchar(20));
create index t08_zy on t08(z,y);
create index t08_yx on t08(y,x);
create index t08_zx on t08(z,x);
create descending index t08_xy_dec on t08(x,y);
create descending index t08_xz_dec on t08(x,z);
create descending index t08_yz_dec on t08(y,z);
create index t08_uvw_asc on t08(w,v,u);
create descending index t08_uvw_dec on t08(u,v,w);
recreate table t09(id int primary key using index t09_pk_idx, x int, y int, z int, u varchar(20), v varchar(20), w varchar(20));
create index t09_zy on t09(z,y);
create index t09_yx on t09(y,x);
create index t09_zx on t09(z,x);
create descending index t09_xy_dec on t09(x,y);
create descending index t09_xz_dec on t09(x,z);
create descending index t09_yz_dec on t09(y,z);
create index t09_uvw_asc on t09(w,v,u);
create descending index t09_uvw_dec on t09(u,v,w);
recreate table t10(id int primary key using index t10_pk_idx, x int, y int, z int, u varchar(20), v varchar(20), w varchar(20));
create index t10_zy on t10(z,y);
create index t10_yx on t10(y,x);
create index t10_zx on t10(z,x);
create descending index t10_xy_dec on t10(x,y);
create descending index t10_xz_dec on t10(x,z);
create descending index t10_yz_dec on t10(y,z);
create index t10_uvw_asc on t10(w,v,u);
create descending index t10_uvw_dec on t10(u,v,w);
commit;
- то при работе 10 коннектов, каждый из которых делает вот это: 1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
set term ^;
execute block as
declare n int = 100000;
begin
while (n>0) do
insert into t01(id,x,y,z, u,v,w)
values ( :n, rand()*1000, rand()*1000, rand()*1000,
rpad( '', 20, left(uuid_to_char(gen_uuid()), 5 ) ),
rpad( '', 20, left(uuid_to_char(gen_uuid()), 5 ) ),
rpad( '', 20, left(uuid_to_char(gen_uuid()), 5 ) )
)
returning :n-1 into n;
end^
- будем видеть выигрыш уже ФБ-3 над ФБ-2.5.
runs_30_elapsed_time.txt: ~45" 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.
run1\tmpins01.log:Elapsed time= 45.50 sec
run1\tmpins02.log:Elapsed time= 45.42 sec
run1\tmpins03.log:Elapsed time= 45.60 sec
run1\tmpins04.log:Elapsed time= 45.85 sec
run1\tmpins05.log:Elapsed time= 45.18 sec
run1\tmpins06.log:Elapsed time= 45.50 sec
run1\tmpins07.log:Elapsed time= 45.36 sec
run1\tmpins08.log:Elapsed time= 45.04 sec
run1\tmpins09.log:Elapsed time= 41.72 sec
run1\tmpins10.log:Elapsed time= 45.84 sec
run2\tmpins01.log:Elapsed time= 47.14 sec
run2\tmpins02.log:Elapsed time= 46.27 sec
run2\tmpins03.log:Elapsed time= 46.36 sec
run2\tmpins04.log:Elapsed time= 47.07 sec
run2\tmpins05.log:Elapsed time= 45.77 sec
run2\tmpins06.log:Elapsed time= 46.83 sec
run2\tmpins07.log:Elapsed time= 46.69 sec
run2\tmpins08.log:Elapsed time= 46.29 sec
run2\tmpins09.log:Elapsed time= 46.08 sec
run2\tmpins10.log:Elapsed time= 44.86 sec
run3\tmpins01.log:Elapsed time= 46.09 sec
run3\tmpins02.log:Elapsed time= 46.11 sec
run3\tmpins03.log:Elapsed time= 46.52 sec
run3\tmpins04.log:Elapsed time= 46.05 sec
run3\tmpins05.log:Elapsed time= 45.57 sec
run3\tmpins06.log:Elapsed time= 44.06 sec
run3\tmpins07.log:Elapsed time= 45.51 sec
run3\tmpins08.log:Elapsed time= 46.72 sec
run3\tmpins09.log:Elapsed time= 46.17 sec
run3\tmpins10.log:Elapsed time= 45.25 sec
run4\tmpins01.log:Elapsed time= 46.22 sec
run4\tmpins02.log:Elapsed time= 46.77 sec
run4\tmpins03.log:Elapsed time= 47.00 sec
run4\tmpins04.log:Elapsed time= 46.52 sec
run4\tmpins05.log:Elapsed time= 46.99 sec
run4\tmpins06.log:Elapsed time= 46.56 sec
run4\tmpins07.log:Elapsed time= 47.05 sec
run4\tmpins08.log:Elapsed time= 46.52 sec
run4\tmpins09.log:Elapsed time= 46.02 sec
run4\tmpins10.log:Elapsed time= 46.02 sec
run5\tmpins01.log:Elapsed time= 45.57 sec
run5\tmpins02.log:Elapsed time= 46.01 sec
run5\tmpins03.log:Elapsed time= 45.72 sec
run5\tmpins04.log:Elapsed time= 45.86 sec
run5\tmpins05.log:Elapsed time= 46.34 sec
run5\tmpins06.log:Elapsed time= 45.53 sec
run5\tmpins07.log:Elapsed time= 45.87 sec
run5\tmpins08.log:Elapsed time= 45.83 sec
run5\tmpins09.log:Elapsed time= 44.52 sec
run5\tmpins10.log:Elapsed time= 45.50 sec
runs_25_elapsed_time.txt: ~55" 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.
run1\tmpins01.log:Elapsed time= 54.74 sec
run1\tmpins02.log:Elapsed time= 55.19 sec
run1\tmpins03.log:Elapsed time= 55.81 sec
run1\tmpins04.log:Elapsed time= 55.74 sec
run1\tmpins05.log:Elapsed time= 55.53 sec
run1\tmpins06.log:Elapsed time= 55.83 sec
run1\tmpins07.log:Elapsed time= 55.69 sec
run1\tmpins08.log:Elapsed time= 55.89 sec
run1\tmpins09.log:Elapsed time= 55.78 sec
run1\tmpins10.log:Elapsed time= 55.89 sec
run2\tmpins01.log:Elapsed time= 56.09 sec
run2\tmpins02.log:Elapsed time= 55.78 sec
run2\tmpins03.log:Elapsed time= 55.70 sec
run2\tmpins04.log:Elapsed time= 56.11 sec
run2\tmpins05.log:Elapsed time= 55.47 sec
run2\tmpins06.log:Elapsed time= 55.74 sec
run2\tmpins07.log:Elapsed time= 56.07 sec
run2\tmpins08.log:Elapsed time= 55.84 sec
run2\tmpins09.log:Elapsed time= 55.82 sec
run2\tmpins10.log:Elapsed time= 55.96 sec
run3\tmpins01.log:Elapsed time= 56.43 sec
run3\tmpins02.log:Elapsed time= 55.75 sec
run3\tmpins03.log:Elapsed time= 56.31 sec
run3\tmpins04.log:Elapsed time= 56.12 sec
run3\tmpins05.log:Elapsed time= 55.51 sec
run3\tmpins06.log:Elapsed time= 56.28 sec
run3\tmpins07.log:Elapsed time= 56.13 sec
run3\tmpins08.log:Elapsed time= 56.40 sec
run3\tmpins09.log:Elapsed time= 56.29 sec
run3\tmpins10.log:Elapsed time= 55.75 sec
run4\tmpins01.log:Elapsed time= 55.33 sec
run4\tmpins02.log:Elapsed time= 55.73 sec
run4\tmpins03.log:Elapsed time= 55.44 sec
run4\tmpins04.log:Elapsed time= 55.00 sec
run4\tmpins05.log:Elapsed time= 55.73 sec
run4\tmpins06.log:Elapsed time= 55.37 sec
run4\tmpins07.log:Elapsed time= 55.70 sec
run4\tmpins08.log:Elapsed time= 55.52 sec
run4\tmpins09.log:Elapsed time= 55.83 sec
run4\tmpins10.log:Elapsed time= 55.60 sec
run5\tmpins01.log:Elapsed time= 56.05 sec
run5\tmpins02.log:Elapsed time= 55.94 sec
run5\tmpins03.log:Elapsed time= 55.75 sec
run5\tmpins04.log:Elapsed time= 55.92 sec
run5\tmpins05.log:Elapsed time= 55.78 sec
run5\tmpins06.log:Elapsed time= 55.89 sec
run5\tmpins07.log:Elapsed time= 55.37 sec
run5\tmpins08.log:Elapsed time= 55.89 sec
run5\tmpins09.log:Elapsed time= 55.96 sec
run5\tmpins10.log:Elapsed time= 55.19 sec
В аттаче - логи прогонов 1...4 (5-й прогон удалил: архив вылез за лимит 150К).
Краткий промежуточный итог: чё-то там с дёрганием генератора "провалилось" в ФБ-3, а в остальном - всё пучком (пока :)). |
