Can I improve speed using FM Server with a slow internet connection?
I'd like to share my database over the internet with colleagues. Multiple tables , with multiple references, including sum-fields summarizing quantities from other tables (all within the same file).
Within the company network there is no problem, when sharing over the internet scrolling through lists with these sum fields is extremely slow.
I made a test with FM Server, instead of just a client with sharing on: still over the internet it remains very slow.
It seems as if the date needed to calculate the sum fields is first sent to the client, and then calculated locally. Shouldn't do FM Server this calculation work first and send just the results to the client?
FM client and server 10
With just three to four clients in mind I wouldn't need to buy FM Server if this doesn't work...
best regards Frank Bachmann