AnsweredAssumed Answered

Find getting triggered incorrectly?

Question asked by StevenRubenstein on May 29, 2012
Latest reply on May 30, 2012 by Stephen Huston

Today we experienced a significant performance slowdown using both FMP 11 and 10 on a file served by FMS 10.


We're investigating this issue -- that's not the headline.


We noticed, during this slowdown, that a script sending the user to a particular layout was triggering a mysterious and lengthy find -- and we suspect that this find was getting triggered all the time, but that we had never noticed it before when performance was normal. When debugging, we could see that the find was triggered after going to the layout, but the layout has no script triggers. (And we can't "debug" or see the actual find process.) We also created a blank layout for this particular table, and again the find was triggered.


We've isolated the problem to record permissions...for records in a different table.


Here's the question: under what conditions might a find get triggered as the result of account permissions? Here's the calc for the limited view of records in the related table:


Confidential ≠ "Yes"


PatternCount ( Confidential Access ; LeftWords ( Get ( AccountName ) ; 1 ) & " " & Left(RightWords(Filter(Get(AccountName); "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz ")

; 1); 1) & "." ) > 0


Also, the find occurs only when the user first goes to the layout. Subsequent visits do not trigger the find, we think.