请问提高向数据库写数据速度的方法
我是用Ado的方式访问Oracle数据库的,同时向两个表写数据,速度很慢,请问有没有提高效率的方法,具体代码如下:
Set cnn = New ADODB.Connection
cnn.Open "DSN=" & str1, str2, str3
Set rs_section = New ADODB.Recordset
Set rs_link = New ADODB.Recordset
sqlstr1 = "select * from " & str4
rs_section.CursorLocation = adUseClient
rs_section.Open sqlstr1, cnn, adOpenDynamic, adLockOptimistic
sqlstr2 = "select * from " & str5
rs_link.CursorLocation = adUseClient
rs_link.Open sqlstr2, cnn, adOpenDynamic, adLockOptimistic
rs_section.AddNew
rs_link.AddNew
For i = 1 To jn
For j = 1 To jsl(i).n
rs_section.Fields(0) = rs_section.AbsolutePosition '//路段路况信息
rs_section.Fields(1) = jsl(i).gridn & jsl(i).linkN
'--------------------------------------------------------------改变时间格式
rs_section.Fields(3) = jsl(i).level
rs_section.Fields(3) = jsl(i).jsects(j).time
rs_section.Fields(4) = jsl(i).n
rs_section.Fields(5) = jsl(i).jsects(j).lev
rs_section.Fields(6) = jsl(i).jsects(j).s
rs_section.Fields(7) = jsl(i).jsects(j).l
rs_section.Update
rs_section.AddNew
Next j
rs_link.Fields(0) = rs_link.AbsolutePosition '//路链路况信息
rs_link.Fields(1) = jsl(i).gridn & jsl(i).linkN
rs_link.Fields(2) = jsl(i).level
rs_link.Fields(3) = jsl(i).time
rs_link.Fields(4) = jsl(i).traveltime
rs_link.Fields(5) = jsl(i).n
rs_link.Fields(6) = jsl(i).lev
rs_link.AddNew
Next i