Yesterday I did an exact match search for 500k records. The search took at least 6-hours to complete (as I have 18M records).
Once the search was complete, I saved the search result, named it, etc. A few hours later, I closed FileMaker as normal. No issues.
Today, I tried to open my database and it keeps hanging. Every few seconds Windows will show that Filemaker has stopped responding. If I wait, it will resume as normal for a few seconds and then loop. I did not receive an error that it was corrupt or closed incorrectly as that did not happen.
If I open a copy of the database I made before the search, it works exactly as it should without issue. So I know it is not an installation issue.
Why is this happening?
Is FileMaker trying to retrieve the search results that were loaded when I last closed? If so, how can I prevent this? I have never see this issue before.
I thought that maybe if I create a new Find that only has a few results and save it, it will prevent this from happening (if it is an issue with the latest find being in the memory), but that did not help.
I could delete the current copy and go to the backup but I'd prefer to get this bug taken care of.