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 |
|
rajani
Constraint Violating Yak Guru
367 Posts |
 Posted - 2008-06-15 : 23:13:56
|
| Hi Guysneed your expert advise on this. in my previous company in our application we used to have 1 sql server connection open all the time to access database .in current company ,framework does it differently like opening connection to database only when needed and closing it straight away.when you look at profiler when doing multiple things in our app one will see many connections opened by our application.my question is which approach is good for performace ? Thanks for advise. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-15 : 23:49:33
|
| Connection pooling has better performance. |
 |
|
|
|
|
|
sql server connections