Anyone seen "Find in progress... Processing Query" pop up randomly in a FileMaker file? It happens even when no scripts are running or during scripts that don’t use Find steps. What could be triggering this?
Anything that looks for related records: portals; fields; calculations; etc.
3 Likes
Thank you for your reply, I will look into this.
There are tons of summary fields and calculations.
The practical approach: I’d duplicate the layout and then delete the objects one by one. That way, you’ll see exactly what’s causing trouble.
The intellectual approach: Look for fields that involve calculations or relationships processing data that doesn’t have an index.
Jan
2 Likes
Or even faster: use a binary search approach and delete half the objects at a a time, using Undo as needed to figure out the offending field(s).
There are tons of summary fields and calculations.
Yes, I've seen it, and it usually alerts me that I've done something sloppy and need to adjust (as mentioned by others) certain relationships, unstored calculations, remove summary fields if not needed, etc. It often occurs (in my experience) when entering a new layout for which data must be collected, or possible navigating to a new record on the same layout where poorly designed script triggers update data on entry. Once one wrangles these events it be more performant and those messages will no longer occur.
I try to avoid, whenever possible, summary fields other than on reporting; especially in List view. In certain list view situations I hide the summary field (if it's needed, e.g. in a footer part) and add a button to "Show Summaries", so the user can show them when needed. A global $$variable is populated to set hide or show, triggered by various actions.
2 Likes