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 |
|
obscure
Starting Member
6 Posts |
 Posted - 2009-11-21 : 06:53:28
|
| Hi all. I was wondering which would be a better choice, to create a separate ODBC connection for each running instance of my application, or make all of them the same one. All instances have multiple threads, which access the same database and manipulate the same tables.I'd like to know what is the advantage of using multiple vs one connection(s) performance and data safety wise. I searched online, but i couldn't find any articles and such. Any help, including links to articles, would be greatly appreciated.Thanks. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-21 : 10:28:11
|
| isn't going to matter performance-wise since each instance of the app will make its' own connection to SQL Server.one is easier to manage |
 |
|
|
|
|
|
Question about ODBC Connections.