Hurtigere INSERT
Her er koden:-------------------------------------------------------------
objdbc.execute("create table a_dantemp(adr char(500));")
strSQL = "SELECT sendari FROM "&db&" WHERE sendari<>'';"
objRs.Open strSQL, objDbc, adOpenStatic, adLockReadOnly
tid2=timer
do while NOT objrs.eof
sendari=trim(objrs("sendari"))
if instr(4,sendari,"?")>"2" then
temp=instr(1,sendari,"//")
blip=instr(temp+2,sendari,"/")
prisur=left(sendari,blip)
objdbc.execute("insert into a_dantemp(adr) values('"&prisur&"');")
end if
objrs.movenext
loop
response.Write "<br><br><br><b>LOOP Tid:</b> "&round(timer-tid2,5)
objrs.close
strsql = "SELECT adr, COUNT(*) as bitch FROM a_dantemp GROUP BY adr HAVING COUNT(*) > '1' order by bitch desc;"
objRs.Open strSQL, objDbc, adOpenStatic, adLockReadOnly
do while NOT objrs.eof
response.Write "<br><b>"&objrs("adr")&":</b> "&objrs("bitch")
objrs.movenext
loop
objdbc.execute("drop table a_dantemp;")
call sqlclose(1,1)
end if
--------------------------------------------------------
Der bliver INSERT'et a_dantemp ca 1300 gange i loopet og det tager ca. 9 sek.
Hvordan kan det blive hurtigere? (Det er INSERT kommandoen der tager næsten 100% af tiden)
