Web Publishing with PHP and FileMaker

Appendix A. Performance Tuning

IN THIS APPENDIX

• Introduction

• Keep Fields on Web Layouts to a Minimum

• Specify Result Layouts

• Minimize Database Requests

Introduction

FileMaker is awesome for rapidly creating, deploying, and maintaining a website. The trade-off for this ease of development is that FileMaker doesn’t always respond to browser requests as quickly as something like a traditional Structured Query Language (SQL) database might. If you are experiencing problems with your performance, don’t be embarrassed—it can happen to anyone. You can do three things to minimize the issue and keep your web users satisfied.

Keep Fields on Web Layouts to a Minimum

When you send a query to a FileMaker layout, FileMaker returns data from every field ...