very slow movenext

User avatar
sal21
PlatinumLounger
Posts: 4370
Joined: 26 Apr 2010, 17:36

very slow movenext

Post by sal21 »

Set CMD = New ADODB.Command
With CMD
Set .ActiveConnection = CONN
.CommandText = "ESTRAI"
.CommandType = adCmdStoredProc
Set prm = .CreateParameter("[INIZIO]", adDate, adParamInput, , CDate(DATA_RIF))
.Parameters.Append prm
Set RS = .Execute
Set CMD = Nothing
End With

i use this code to extract the rs value.

But during the loop the rs.movenext is extremly slow!!!!!


note:
the access table are on a lan dir

peraphs i nee to loop a disconnected recorset?

User avatar
HansV
Administrator
Posts: 78628
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: very slow movenext

Post by HansV »

I can't help with that, sorry.
Best wishes,
Hans