This is because a computer can only process one thing at a time. A dedicated FileMaker Pro host is fastest. You can host databases on a server, on a workstation or on a separate computer dedicated to hosting FileMaker databases. HOST THE DATABASES ON A COMPUTER RUNNING ONLY FILEMAKER PRO This is commonly done by setting up the host computer to open the databases automatically when the computer is booted. Then make sure that the computer that is supposed to be the host computer opens the databases first.

To avoid this problem, locate the database files on the host computer. This not only results in a network between the host and the database, but also a network between multiple hosts. The worst case scenario is when related files reside on a server and some the databases are opened first by one computer and others are opened first by other computer(s). When multiple guests use a database, the 'traffic' between the host and the database file on disk increases accordingly. When a guest performs an action on a database, that communication flows through the host to the database file, then back through the host to the guest. This is because all communication between the database and the users is through the host. This may be only marginally slower if you're the only person using the database, but if there are guests using the database, their access to the file will be much slower.

If you open a database as the host and the database is stored on a remote file server, then there is a network connection between the host and the database. (The host computer is, by definition, whichever computer opens a FileMaker database first). The database files should reside on a hard drive attached to the host computer. LOCATE YOUR DATABASES ON THE HOST COMPUTER Dial-up connections using modems are extremely slow. Remote connections should be via a fast broadband connection, such as a T1 line, DSL or cable modem. If possible use switches instead of hubs, hubs broadcast data where as a switch will give a more direct route from the client to the server. The faster the connection the better the network performance, especially for many users on a large network. Local area networks should be at least 10Mb/sec or better. The best performance from FileMaker Pro and FileMaker Pro Server can be achieved by implementing as many of the following recommendations as possible. Besides networking hardware and software, structure and design of the database system may effect performance. The performance of a FileMaker shared database on a network is determined by many factors.

Filemaker pro 17 network data share