Recently my primary solution that I develop has been running extremely slow and I'm having trouble figuring out what changed since it's used very regularly and the performance drain was pretty sudden and drastic.
Often my users will get the dialog box from FileMaker about "Remaining Records to Sort..." and so I believe that the performance drain has something to do with FileMaker sorting things in the background. The problem is that my scripts are not calling the "Sort Records" command or even "Sort Records by Field" step.
What else can cause this sort box to appear? Sorting on portals? Sorts in the relationship graph? All of my fields that need sorting are indexed, so it's also hard to imagine why these might be taking so long.