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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2005-02-02 : 05:28:19
|
| if i have an sp that I want to access from asp -- will it have problems if there are up to 50 connections per second?what's the best way to do the connection to the stored procedure from asp not to cause network problems on the server. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-02-02 : 12:33:42
|
| 50 hits per sec in itself shouldn't cause a problem (as long as you have connection pooling and it can cope with that).Depends a lot on what the SP is doing and how it copes with contention.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2005-02-02 : 12:50:39
|
| all I want it to do is add one row to a table with 3 fields. not a lot of work.What is the best way to do the connection (i'm using asp) |
|
|
|
|
|
|
stored procedure -- too many hits