FMP12 performance issue - host vs. client
I have a calculation-intensive routine that is executed upon opening my solution. It is periodically needed again while the user is in the database.
The solution is implemented in a shared FMP12 environment.
On the host, the calculation takes about 12 seconds. The same calculation with the same data on a client (host and one client is all that's in the network) takes a minute and 20 seconds - 6 to 7 times as long. This is repeatable.
Should that be expected? What should I look for?