
More often than not, the "down" comes back fine but the "up" is a dismal one or two megabytes. When a client says they want to deploy the solution I'm designing to remote users, I usually have them conduct a speed test. However, what a lot of companies forget about is the "up". More is usually better and how much of a pipeline to the internet you need depends on how much traffic your FileMaker databases have. This often translates to ten or twenty megabytes "down" which is very reasonable to pull data out at a good pace. In my experience, most small to medium size companies have whatever internet access is provided by the local cable company. The biggest bottleneck I find when deploying across a WAN is the throughput of the internet. Make sure to read the first article to fully optimize a FileMaker solution for WAN deployment:Īll the information in this article is available on the internet right now in articles, videos and other mediums so I'll try to specify where I digested the information whenever possible.

This is the second article in a series of two articles. Instead, what I have here is a cheat sheet that will assist you in resolving speed issues. There are so many factors that play into how a solution performs that it's nearly impossible to provide the right answer for everyone. Hardware and networking are usually secondary to proper design but it can make a big difference in how your solution performs if you have sub par equipment.

You also need to optimize your hardware and network on your FileMaker Server machine. Just because you streamlined your solution during the design phase doesn't mean it's going to react efficiently across a LAN or WAN. The Philosophy of FileMaker recommends PCI! I always knew this to be true with Insert Calculated Result, but I had just assumed that Set Field had to have a field reference to work. Set Field Peculiarities Maybe everyone else knew this, but I just discovered it: If you don't specify a target field with Set Field then it will set the calculation to the currently selected field. Email John Mark Osborne or call John Mark at (909) 393-4664 to find out more about this service.

Over programming hurdles via GoToMeeting. Meta-consulting is a service Database Pros offers to help other developers Support this site by clicking on a sponsor below or becoming a patron!

The Philosophy of FileMaker - Server Optimization
