Considering database performance

Database design can impact FileMaker Server's performance. When you design your databases, consider the clients that will be using the databases and how you might simplify the design for those clients.

• To improve performance for all clients, limit the use of:

  • external tables

  • complex table relationships

  • unstored calculations

  • value lists

  • script triggers

  • the Perform Script on Server script step

• For FileMaker Pro clients, optimize layout performance, improve search performance, reduce conditional formatting, and disconnect users from the server when they are idle. See FileMaker Pro Help.

• For FileMaker WebDirect clients, limit the number of portals and panel controls and limit the number of objects displayed in List View and portals. See FileMaker WebDirect Guide.

• For Custom Web Publishing clients, limit the number of records returned for Find requests and reduce the prevalidation of field data. See FileMaker Server Custom Web Publishing Guide.

• To identify performance issues with hosted databases, use the Top Call Statistics setting in Admin Console. See FileMaker Server Help.