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 |
|
nice123ej
Starting Member
48 Posts |
 Posted - 2009-12-01 : 19:50:33
|
| HiI want to know which is better in .Net Web Appa- To Open SQL connection when needed and close immediately after get results. (a single user may open more than 200 connection per session but all will close immediately after returning the results. imagine for 1000 user)b- Open SQL Connection, Keep it open and store it in a session so we can use the same connection again and again. (a single user will keep just 1 connection open for the session but it will remain open for long time. imagine for 1000 user)so where to go (a) or (b) and why?Thanks |
|
|
|
|
|
Connection Pooling