W
wanglong5
Unregistered / Unconfirmed
GUEST, unregistred user!
???困惑啊,听说oracle好,菜鸟放弃了sqlserver,学oracle,可做了个实验发现sqlserver比oracle快啊,请进来看看啊。 ( 积分: 50 )<br />我sqlserver有个表有16万条数据,我导到了oracle里,我做了个程序,测试sqlserver快还是oracle快,我用ado测的,语句如下:
var
sql: string;
starttime, endtime: real;
begin
starttime := GetTickCount;
sql := 'select * from 广东省';
adoquery1.close;
adoquery1.sql.clear;
adoquery1.sql.add(sql);
adoquery1.open;
endtime := GetTickCount;
showmessage(floattostr(endtime - starttime));
发现打开表,sqlserver用了73.266秒,oracle用了143秒,怎么会这样啊,学oracle有用吗 ??
var
sql: string;
starttime, endtime: real;
begin
starttime := GetTickCount;
sql := 'select * from 广东省';
adoquery1.close;
adoquery1.sql.clear;
adoquery1.sql.add(sql);
adoquery1.open;
endtime := GetTickCount;
showmessage(floattostr(endtime - starttime));
发现打开表,sqlserver用了73.266秒,oracle用了143秒,怎么会这样啊,学oracle有用吗 ??