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 |
|
cr8nk
Yak Posting Veteran
77 Posts |
 Posted - 2001-10-16 : 16:45:58
|
| Hello, I have a performance question. In general, I have read that developers should stay away from cursors because they are a burden on the server. I am going to be calling stored procedures from a VB 6 application. I am going to have to call the same stored procedures over and over from the application with different parameters. I am wondering which would be better creating a loop in visual basic and calling the same stored procedure x times or creating a sql server cursor that calls the stored procedure? I have read that pushing all the data manipulation onto the server is best |
|
|
|
|
|
server side cursors vs looping in VB