![filemaker optimal layout size filemaker optimal layout size](https://windows-cdn.softpedia.com/screenshots/FileMaker-Server_1.png)
Let's move on to the next item in the article that recommends running only FileMaker Server on your host machine. I actually send it and other articles mentioned in this blog posting to any client where they are setting up their own server. It's a must-read article that I will be referring to quite a bit throughout this blog posting. Optimizing Network Performance for Shared Databases I've known about this deployment issue for quite a while but it's also included in the FileMaker Knowledge Base in article titled "Optimizing network performance for shared databases": Crazy, I know, but what can you do except keep fighting the good fight. Then, it has to push it back across the same network to save it.ĭespite my constant warnings for the last twenty years in technical support at Claris and my professional career as a developer, people still deploy in this unsafe and inefficient manner to this day. First, FileMaker Server has to go across the network and pull data to the local machine at speeds slower than a hard drive. In fact, placing your FileMaker solution on a remote volume could even crash your solution because of all the extra network activity. FileMaker is a hard disk based database system so you need to make sure it can get data quickly. It should be on the local hard drive of the FileMaker Server (FMS).
![filemaker optimal layout size filemaker optimal layout size](https://www.zdnet.com/a/hub/i/2017/06/16/ad9d042c-01bd-40ba-bc12-e1f3f0026db4/filemaker-16-layouts.jpg)
Sometimes location limits the options but a lot of the time it's just the cable company providing a service that meets most of the customer's needs for surfing the internet with a web browser (which is mostly pulling data down).ĭon't put your FileMaker file on DropBox or a file server. Even from my home office, I have 100 down and 100 up.
![filemaker optimal layout size filemaker optimal layout size](https://blog.supportgroup.com/hubfs/FileMaker_19_Calendar/FileMaker19-Calendar.jpg)
This means data coming in is speedy but data being pushed out to users is unreasonably slow. 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. For example, you will be able to search for an email address by including the at sign Beginner Video Trainingīeginner, Intermediate and Advanced Video Training This will make FileMaker index include upper ASCII characters, so you can search for values without enclosing them in quotes. Searching Higher ASCII If you look at the storage options for a field in Manage Database, and you see that it is set to a particular language, you may not think much about what it can do for you. 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 The Philosophy of FileMaker recommends PCI! Support this site by clicking on a sponsor below or becoming a patron! The Philosophy of FileMaker - Server Optimization