Hello,
I'm new to FMS and I'm trying to figure out why opening a database is taking so long. When I open the DB over our gigabit LAN things work smoothly and the layout opens in 1-2 seconds, but if I switch to our Wireless LAN opening the same layout can take up to 90 seconds and if I try to connect via VPN from home then we're into the minutes time frame. All the calculations occur server side in FMS correct? So if it's sending the same amount of results data why does a drop in connection speed cause such a drastic change in load times, unless of course wer're sending a HUGE amount of data to the client. Is there a way to track how much data is getting sent to the client?
The size of the database is really quite tiny; something like 200k records / 3k fields.
Server Specs:
10.7 Mac
2x 2.93 Ghz Hexcores
16GB of 1333 Mhz DDR3 ram.
The only application it runs is FMS though it does alos serve a file store.
The CPU according to Activity Monitor never gets above 1-2% usage.
