14 for 14: Ditch those Cartesian Joins, use Refresh Portal Instead (maybe!)

Discussion created by weetbicks on Jun 28, 2015

Four years ago we wrote an article about how you can refresh portals and relationships without the need to flush the entire cache. The technique involved using a Cartesian Join. Now, over four years later FileMaker 14 has given us a supported way to do this with the Refresh Portal script step.  In this article we demonstrate how the step can be used by comparing it to the example given in our first article on the subject. We also cover some situations where cartesian join may still be the preferred method of refresh.

Click here to read the full article at FileMaker Weetbicks