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 - 2001-05-04 : 08:36:03
|
raj writes "This is reagrding the time taken to execute a stored procedure in Version 6.5.I have used cursor to insert the records in a table which has a data of about 50,000 rows existing. The stored procedure takes around 10 seconds to get executed which in turn becomes 1000 seconds when it has to be excuted 100 times.
does use of cursor effect performance in MSSQL 6.5" |
|
|
|
|
|
SQL(6.5) performance when Cursors are used.