Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-20 : 08:40:54
|
| john writes "When I attach a database to the SQL 2000 Enterprise Dev environment, when I execute (call) an update store procedure from visual basic it takes 100th of a second to execute. But when I attach the same database to an instance of MSDE it takes uo 2 to 3 seconds. How can I improved the the execute time using the MSDE environment? I use ado execute, here is an example...Set rsUpdate = New ADODB.RecordsetSet rsUpdate = gConn.Execute("updPollTempSuccess " & "'CabsRev1'" & ", " & lID & ", " & sngTemp_Value & ", '" & dteStatusDTG & "'", iRow)Set rsUpdate = Nothing" |
|
|
|
|
|
MSDE vs. SQL 2000 Ent. Dev environment