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 |
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
 Posted - 2008-04-17 : 23:39:29
|
| Hi all, I'm doing a code review of an app that is running slowly and I'm trying to identify the bottlenecks. The code is in a DTS package and is basically a whole load of VBScript calling stored procs etc. The code uses 2 different approaches to calling stored procs - one using the ADO Command object and the other using a dynamic SQL string that contains the 'EXEC' statement and the parameters, which is then executed using the Connection.Execute method. Does anyone know if the Execute method is slower than calling the same proc using the Command object? I was thinking that perhaps the Connection.Execute method expects to create a Recordset object, but then the Command.Execute method also can return a recordset. Cheers,Tim |
|
|
|
|
|
ADO performance in calling stored procedures