2 of 2 people found this helpful
I have more information to share about this:
Some of the portals on the layout had an old work around for an issue with portal updating. In some versions prior to 14, portal updating seemed sporadic, sometimes when updating fields, some portals that had that field in the relationship would not update. To get around this, and not have to use the flush joined cache results in a script, you could add a cartesian join to the portal relationship and update the left side of the cartesian join to get the portal to update.
I took out this cartesian join today, and changed the script to refresh portal. So far, things seem to have improved, but will keep watching during busy times.
Thank you for your post.
I started working on this last night and just finished testing. I have been unable to reproduce the issue in my test file in FileMaker Pro 15 on Windows 7 Professional SP1 (64-bit) while hosting on FileMaker Server 15. Please let me know if your changes have resolved the issue. Otherwise, if you could provide a file for testing I can send you instructions to do so.
1 of 1 people found this helpful
It appears that getting rid of the cartesian relationship and using the refresh portal command instead worked. We have not seen the same issues with speed since then.
Thanks for taking the time to test this.