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 |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2008-06-18 : 04:30:14
|
| What's the benefit of Multiple Active Result Sets? When would you use it. Read the BOL article but still not quite sure what its use is. there doesn't seem to be a performance gain. So what's the purpose? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-06-18 : 04:38:49
|
| it gives you the ability to perform multiple operations on one connection.so you don't have to open and close more than one._______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
 |
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2008-06-18 : 04:41:59
|
| Doesn't the connection pool kind of take care of that for you anyway?I only ever use one connection per database in my client apps - which I keep open throughout the duration of the app running. Why would I need more than one? |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-06-18 : 04:50:37
|
| no. if you have to open 2 connections the connection pool will still have to open 2 connections.the conn pool is just meant as a fast access storage for conn objects.keeping a connection open for the whole app time isn't really advisable. the connections should be opened as little time as possible.and frankly MARS in my opinion wasn't means for standard apps._______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
|
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2008-06-18 : 10:14:34
|
quote:
Originally posted by spirit1
no. if you have to open 2 connections the connection pool will still have to open 2 connections.the conn pool is just meant as a fast access storage for conn objects.keeping a connection open for the whole app time isn't really advisable. the connections should be opened as little time as possible.and frankly MARS in my opinion wasn't means for standard apps.[/b]
I've never understood the connection pool fully. Still don't I must confess.We've opted for keeping connections open for the day because of the performance cost of opening and closing it all the time.Sounds like no one probably uses MARS then. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-06-18 : 10:24:07
|
| i haven't seen it being used yet._______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
|
|
|
|
|
|
MARS