possible LINQTOSQL active connections
-
I made an database application using LINQTOSQL IN c#(using visual studio) I just wanted to know how many different connections at a same time can be made from different computers? (let say to a same table of database?)
This depends on your design but basically the answer is unlimited. Think about the big web sites, do you think they can accept limitations on the connections to their databases, no they design their systems to meet the projected requirements.
Never underestimate the power of human stupidity RAH
-
I made an database application using LINQTOSQL IN c#(using visual studio) I just wanted to know how many different connections at a same time can be made from different computers? (let say to a same table of database?)
wjbjnr wrote:
I just wanted to know how many different connections at a same time can be made from different computers?
64k. Or some number pretty close to that. There are gotchas for that. 1. They must exist at the same time. 2. The number can be smaller, quite a bit, if the clients are rapidly opening and closing connections. 3. The number can be smaller, specifically 5000, if you have not explicitly updated the MS Windows registry of the server box. This is the maximum and is impacted by 2 above as well. None of that has to do with the database and certainly not tables. It has to do with the IP address. So if you have a computer with more than one real IP Address then each is subject to the same restrictions. See the following http://msdn.microsoft.com/en-us/library/aa560610.aspx[^] Be very careful if you start messing with those values.