Fast Filtering Portals

[FileMaker Magazine]

When you first develop your FileMaker solution you're typically dealing with sample and/or test data. Everything works great. It's fast and efficient and you're guessing users will just love using it. Until you hear feedback like "It takes forever to simply see a list of people to pick from."

As you scratch your head wondering why things got slow, it's likely because you didn't think about what's happening on every record of that simple little portal. Your once wonderful complex filter, which was working just fine on the 1,000 records, now chokes to death on the 10,000 records in the real world.

You ask yourself "Is there something I can do to make this faster?" and you find this video about Fast Filtering Portals. Yes, is the answer. You can optimize that portal filter such that the fewest number of CPU cycles are required in order to show a user's desired results. The trick is knowing how to make it happen with the tools we have available within FileMaker. Need to make your portal filters faster? This video will likely have the answer.

Click the title or link to this article to view the video.

View the full article