Hi - I've done a bit of searching and haven't come across a definitive answer on this. It seems that there is a rule that there is a 20 connection limit on Windows 7 Pro 64-Bit but the responses seem to vary on what exactly this means. So, with the setup below, what would the limits be?
Windows 7 Pro 64 Box running MySQL on port 3306
Question 1: How many simultaneous connections can be received by the MYSQL instance on TCP Port 3306? Typically the box would receive connections from 4 to 6 Windows Servers on the same LAN. 5 of those would have perhaps 2 simultaneous connections open at one time. The main Windows server would have perhaps 300 to 500 connections open on this port.
Question 2: If setting up a shared folder on the Windows 7 Pro 64 Box with one Windows Server connected to it to access the files on that server. Basically the "Windows Server Box" would pull a file from the Windows 7 box via the file share, manipulate it locally and then output the file via IIS to an outside client. The outside client would never be connecting to the Windows 7 box. But the Windows Server box might be pulling 100 or more files at one time. What sort of problem or connection limit could be experienced in this scenario?
Thanks in advance