I have been developing and scripting my first database over the last several months and just began to test how it would work while sharing it from one mac to another across the web. I was astonished to see many relatively fast operations slow down to a crawl. A routine operation of medium complexity that took less than 3 seconds working on a single machine took between 25 and 53 seconds working remotely through internet sharing, and about 100 seconds doing the same through the free hosting site Neo Code.

Is there any remedy for this slowness? I am wondering whether something in my scripts (perhaps using Refresh Window in a loop with Flush Cached Join Results selected?) is slowing me down?

Would I need to move the host database to a server to achieve reasonable speeds? I.e., is sharing a database from one pc/mac to one or more others intrinsically slow when a lot of scripting is involved?

Using Macs with 1000BaseT, max RAM and high-speed/capacity modems/service on each side is a must.

Be sure you're using a hosting provider with an excellent network. FileMaker Network Sharing is very latency sensitive.

We are literally zero hops from the Level3 backbone:

http://www.pointinspace.com/

Also, minimize the amount you use operations that go back and forth to the server a lot - like summary fields, unstored calcs, complicated portals, etc.

- John

We found the same problem with NeoCode. Veeeeery slow.

We use MacUSA hosting for our FileMaker hosting services. MUCH faster. And MUCH better technical support.

Best Wishes,

Patrick