How local is local?
Still connecting over a local network to a hosted copy of the file or opening it directly on the host computer?
If opening as a client, the only difference is networks speed. If opening as a host, there are other factors involved in serving up the database to make it accessible over the network.
Host is opening it and sharing on machine A.
Machine B on same gig LAN = lightening fast
Machine B over internet to Machine A via host lookup = super slow yet after testing this a little more, I think once we increase our circuit speed where Machine A is, I think performance will improve. We're currently 14.7 down / 1.85 up so I'm guessing that's the problem. 1.85mbps uplaod speed is the slow... But my wonder was is FMPro really that dependant on network speed to push a sort that should be happening locally.
I.E., Locally Machine A does the same sort done on Machine B in .5 seconds (4000 records)
Machine B local LAN = around 10 seconds
Machine B over the internet = 90 seconds
Which means why for the love of everything digital would hand-shaking between B and A to update that "Records Sorted box countdown" be so massively intensive? :)
Can't wait for our upgrade.