1 Reply Latest reply on Feb 15, 2012 12:29 PM by philmodjunk

    Filter portal vs Relationship criteria

    dbail22@comcast.net

      Title

      Filter portal vs Relationship criteria

      Your post

      I need to have a layout that is accessed remotely using filemaker network sharing that has several portals on the page.  I am wondering what method is the fastest when accessing the layout, setting a filter portal like, x=alpha and y = beta and z = omega and a = b and b=c, or to create that in the relationship diagram using the same criteria.  There needs to be four portals with similar critera and there are about 40,000 records involved in the criteria. 

        • 1. Re: Filter portal vs Relationship criteria
          philmodjunk

          Don't know the answer, but you might try experimenting with both to find out and if you do, please let us know what you find out. I'd bet on the relationship based option being faster than the portal, but don't really know for sure if that's the case.

          I do know that you should avoid the Refresh Window [flush cached join results] script step on such a layout and I did find a snippet of info on global fields that suggests that moving all global fields not used in your relationship and/or portal filters to a separate table might improve performance.