FileMaker

How to enhance performance of web application with large records in FileMaker database?

Dropdown list using FM-CWP for large records:

With Custom Web Publishing (CWP) FileMaker allows to build web applications using PHP as Front-End and FileMaker as Back-End. This is achieved using FMPHP API provided by FileMaker.

Almost every web application consists of forms that have a dropdown list/ selection list. For example:

dropdownlist

In case of Dynamic dropdown lists, data has to be fetched from backend FileMaker database every time user accesses. If there is large number of records, then fetching them from database and displaying on Web Page takes time to load and results in the slowness of the web page.

In order to avoid this and make the experience friendlier & faster for the user, following technique explains how it can be achieved in a simple way,

  • Create a text file with all the required data separated by enter key in it.
    ex.
    Value1
    Value2
    Value3..
  • This data will be the initial data containing in the FileMaker field on which you would like to base dropdown list.
  • Place this file in the same location as your web page containing the dropdown list.
  • Then in the PHP web page, using file read operations and while loop, fetch the data and display in the dropdown list.
  • Create one more PHP web page, which will fire a query on FileMaker table/field to get dynamic data for the dropdown list and write to the text file described above.
  • Admin person can call this web page via the web browser or web viewer of FileMaker whenever there is an update to the field data.
  • This technique is more effective when the data in the required field is modified less frequently.

MetaSys Software develops custom applications using Dot Net, PHP-MySQL, and FileMaker Pro. We have a team of Certified FileMaker developers with over 12 years of experience building FileMaker applications.

As a FileMaker Business Alliance Member, we are also authorized resellers of FileMaker licenses. If you are looking to buy any of the FileMaker licenses then please click here.

Advertisements

2 thoughts on “How to enhance performance of web application with large records in FileMaker database?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s