执行的代码如下:
with adocmdImport do
begin
//import data to the report table
strSQL:=' insert into charge_report(acct_id,acct_nbr,duration,meter,charge,acct_month)';
strSQL:=strSQL+' SELECT acct_id,acc_nbr,SUM(duration) AS duration,SUM(meter) AS meter,SUM(ROUND(charge / 100, 2)) AS charge, acct_month';
strSQL:=strSQL+' FROM OpenDataSource(''Microsoft.Jet.OLEDB.4.0'',';
strSQL:=strSQL+'''Data Source='+strPath+';User ID=Admin;Password=;Extended properties=dBase 5.0'')...'+strFile;
strSQL:=strSQL+' GROUP By acct_id,acc_nbr,acct_month'; CommandText:=strSQL;
Execute;
end;
数据量有40万条
但sql2000也不至于慢到无响应的程度啊
with adocmdImport do
begin
//import data to the report table
strSQL:=' insert into charge_report(acct_id,acct_nbr,duration,meter,charge,acct_month)';
strSQL:=strSQL+' SELECT acct_id,acc_nbr,SUM(duration) AS duration,SUM(meter) AS meter,SUM(ROUND(charge / 100, 2)) AS charge, acct_month';
strSQL:=strSQL+' FROM OpenDataSource(''Microsoft.Jet.OLEDB.4.0'',';
strSQL:=strSQL+'''Data Source='+strPath+';User ID=Admin;Password=;Extended properties=dBase 5.0'')...'+strFile;
strSQL:=strSQL+' GROUP By acct_id,acc_nbr,acct_month'; CommandText:=strSQL;
Execute;
end;
数据量有40万条
但sql2000也不至于慢到无响应的程度啊
另外如果你直接在数据库中运行此语句的话是不是也这么慢?