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 |
|
sasan_vm
Yak Posting Veteran
51 Posts |
 Posted - 2011-07-07 : 16:11:51
|
| HelloIn client/server windows application with 50~100 online user, that join to server on global wanwhat is the best strategy for transaction with sql-server:1. At application startup with ADO connect to sql-server and use it in all transcation with sql-server.2. On any transcation create new connection to sql-server and by finishing transaction close connection.client connected to server with global private wan at least 2Mbit p/s bandwidth.please help me select best situation.Regards,sasan. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-07-07 : 17:10:00
|
| #2 is better. |
 |
|
|
|
|
|
Client/Server application