Slowness with high request volumes
We run a 26gb database on FileMaker Server 11 in a company of over 300 people. We sometimes have over 200 clients connected to the server. We occasionally have the entire system grind to a halt, and at these times, the Client Statistics tab in the Admin Console shows requests piled up from about 50 users, and most/all of them have Wait Times of 15-20 seconds. I've been telling people that I suspect the problem to be related to threading: when too many users are making too many requests, the server spends so much time and resources rotating between all of those requests that it hardly has any time to actually fulfill them. Can anyone corroborate this theory? Does anyone else have trouble with high user or high request volume?