A simple Find takes minutes or freezes. There are only 1800 records in this table. cancelling the Find takes forever or freezes as well.
I have never experienced this before. Anybody got the same problem? Any fixes?
Not enough information I'm afraid. how many fields in the record and how many of those are unstored calcs or summary fields that are on the layout you use for searching?
Can you see corresponding stats spike up in the FMS stats log?
Good point, I've added some fields to the layout. Going to find out if they are unstored or summary now!
Solved: I had an unstored field on the layout. ( ...Should have been temporarily only )
And even worse, the field was sourced from an external table on a closed database. (...bad practise)
A left over from testing caused all this problem.
Retrieving data ...