First, some thanks. This discussion group has really beeen a great resource. Questions submitted are always answered quickly and professionally.
I'm sure I'm not the only developer having trouble with the promise of FileMaker Go. It's an absolutely fantastic product, but my clients have expectations of performance remotely accessing their served databases from their iPhone 4s. I'm not sure what to do next.
If they remotely access the FMPS database over the internet, it is unacceptably slow. Even using high-speed hosting services do not seem to make any difference. If they download the database (via Dropbox, etc.) and store it on their device, it will be much faster, but is not up-to-date with current changes until downloaded again. Since there might be many iPhones accessing the database during the day, the opportunity for inaccurate information is magnified. Plus, the served database is only current when the remote version is uploaded.
Of course, the client wants FM Go to act as quickly as any other iPhone App... instantly! I realize that there are many ways to optimize the database to minimize the waittime for some procedures, but overall, even after these tweaks, it can be incredibly SLOW. Unfortunately finds and sorts must occur occasionally. Performance speed seems to be related to where the database resides.
Question: Is there a way to script an download to the iPhone/iPad of the served database so that it will be locally stored on the remote device? Changes to the database would be made remotely and uploaded to the served database at the direction of the user, when a fresh copy of the entire database is again downloaded to the device.
Perhaps I'm moving in the wrong direction. I guess I'm a frustrated fan. Any suggestions would be appreciated.