大家知道都有哪些国产数据库

〇〇

myth8860 发表于 2012-9-24 17:18
我没64位的windows哦

64位安装程序可以用，但却安装到x86 目录

〇〇

〇〇 发表于 2012-9-24 15:36
说实话，插入还是挺快的，100万条12秒
SQL> create or replace procedure ptest (n integer ) IS
2    i  ...

forall测试不如for快
create or replace procedure ptestall (n integer,bsize integer ) IS
num integer:= 0;
type ta is table of a.a%type;
taa ta;
begin
taa.extend(bsize);
for k in 1..n/bsize loop
for i in 1..bsize loop
num:=num+1;
taa(i) := num;
end loop;
forall j in 1..bsize
insert into a(a) values(taa(j));
end loop;
commit;
end;

SQL> exec ptestall(1000000,100)

Use time:15015 ms.
ok.


SQL> truncate table a;

Use time:16 ms.
ok.


SQL> exec ptestall(1000000,1000)

Use time:14295 ms.
ok.

〇〇

每批越大，越快，但都不如for快
SQL> exec ptestall(1000000,10000)

Use time:13436 ms.
ok.


SQL> truncate table a;

Use time:0 ms.
ok.


SQL> exec ptestall(1000000,100000)

Use time:13218 ms.
ok.

myth8860

〇〇 发表于 2012-9-26 15:54
forall测试不如for快
create or replace procedure ptestall (n integer,bsize integer ) IS
num integ ...

你这个表没主键，加上主键试试

myth8860

〇〇 发表于 2012-9-26 15:57
每批越大，越快，但都不如for快
SQL> exec ptestall(1000000,10000)

f

〇〇

myth8860 发表于 2012-9-28 17:32
你这个表没主键，加上主键试试

SQL> create table a(a number(38,2));

Use time:16 ms.
ok.


SQL>

SQL> alter table a add primary key(a);

Use time:62 ms.
ok.


SQL> create or replace procedure ptestall (n integer,bsize integer ) IS
2    num integer:= 0;
3    type ta is table of a.a%type;
4    taa ta;
5    begin
6    taa.extend(bsize);
7    for k in 1..n/bsize loop
8    for i in 1..bsize loop
9    num:=num+1;
10   taa(i) := num;
11   end loop;
12   forall j in 1..bsize
13   insert into a(a) values(taa(j));
14   end loop;
15   commit;
16   end;

Use time:62 ms.
ok.


SQL>

SQL> create or replace procedure ptest (n integer ) IS
2    i integer := 0;
3    num integer:= 0;
4    begin
5    for i in 1..n loop
6    num := num+1;
7    insert into a(a) values(num);
8    end loop;
9    commit;
10   end;

Use time:0 ms.
ok.


SQL>

SQL> exec ptest(500000)

Use time:5928 ms.
ok.


SQL> truncate table a;

Use time:265 ms.
ok.


SQL> exec ptestall(500000,100)

Use time:4836 ms.
ok.


SQL> truncate table a;

Use time:125 ms.
ok.


SQL> exec ptestall(500000,500)

Use time:5133 ms.
ok.


SQL>

〇〇

〇〇 发表于 2012-9-28 18:43
SQL> create table a(a number(38,2));

Use time:16 ms.

再次测试，for还是比100的forall慢
SQL> truncate table a;

Use time:93 ms.
ok.


SQL> exec ptest(500000)

Use time:5086 ms.
ok.

myth8860

〇〇 发表于 2012-9-28 18:43
SQL> create table a(a number(38,2));

Use time:16 ms.

nice job ！

〇〇

myth8860 发表于 2012-9-29 16:56
nice job ！

为什么主键会影响for和for all呢

〇〇

〇〇 发表于 2012-9-29 20:33
为什么主键会影响for和for all呢

插入10万行也要15秒，怎么回事？

SQL> create table test_fbi( id int,name char(10));

Use time:234 ms.
ok.


SQL> declare
2    begin
3    for i in 1..100000 loop
4    insert into test_fbi values(i,i);
5    end for;
6    end;

Use time:15694 ms.
ok.