AnsweredAssumed Answered

FINDS and RELATED RECORDS using PSoS

Question asked by RussW on Sep 10, 2016
Latest reply on Sep 11, 2016 by wimdecorte

Not sure my title makes any sense, sorry for that, but I guess that's also a statement of how confused I am.

 

I am in the process of optimizing my solutions to make maximum use of PSoS when appropriate.

 

I have read that doing a FIND on the sever side is much faster. But once I find that record and throw it up on a local layout which has one or more portals to other tables, am I losing all the gains I made doing the FIND on the server side? If the relationships to the records from the various tables all have to have the full tables of each of those portals downloaded to my local machine to find just the related records, it seems to me that doing the FIND fast is an insignificant improvement. Or, does FMP know to retrieve and transfer over the WAN only the related records and not all of the rest?

Outcomes