--- franklin gray <[EMAIL PROTECTED]> wrote: > For connection pooling to work, doesn't the objects that create the connection be >working in a > Com+ environment?
In the ADO model connection pooling was implemented by a resource dispenser in the driver. So it was in no way dependent on COM+. In ADO.Net it is done in the .Net framework itself. > If I have 5 clients that are retrieving some data, I have 5 connections open, right? > Right now > the SQL Server is on the same machine as the Web Service, so we don't have much >network traffic > dealing with the connections, but we trying to design it to be scalable so that some >users will > use different DBs and different Servers when we get into the hosting phase. I >wonder how much > of a problem that will be. If you want it to be scalable, then try and emulate the production environment as much as possible, and performance test often. Peter __________________________________________________ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com You can read messages from the Advanced DOTNET archive, unsubscribe from Advanced DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
