vc ado 读取oracle为啥很慢?if(osa.dwMajorVersion==5)
m_pConnection->Open("Provider=MSDAORA.1;User ID=READEXPORT;Password=123456;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.13)(PORT=1521)))(CONNECT_DATA=(SID=FIXDB)));Persist Security Info=True","","",adModeUnknown);
else
m_pConnection->Open("Provider=OraOLEDB.Oracle;User ID=READEXPORT;Password=123456;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.13)(PORT=1521)))(CONNECT_DATA=(SID=FIXDB)));Persist Security Info=True","","",adModeUnknown);
select name,ssn from dbtotal.account vc ado去连接oracle,同网段内网,5000条数据读取俩字段,逐条读取,需要30秒+,请问该如何提速?
m_pConnection->Open("Provider=MSDAORA.1;User ID=READEXPORT;Password=123456;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.13)(PORT=1521)))(CONNECT_DATA=(SID=FIXDB)));Persist Security Info=True","","",adModeUnknown);
else
m_pConnection->Open("Provider=OraOLEDB.Oracle;User ID=READEXPORT;Password=123456;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.13)(PORT=1521)))(CONNECT_DATA=(SID=FIXDB)));Persist Security Info=True","","",adModeUnknown);
select name,ssn from dbtotal.account vc ado去连接oracle,同网段内网,5000条数据读取俩字段,逐条读取,需要30秒+,请问该如何提速?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货