Faster Find Option
Hi Ive been working on a project and it seems I just can't seem to get the results thats I am looking for simply because Im sure I'm not using filemaker to its best. However at the moment I now have a database with over a million records and 100 fields (ALL Indexed). I tried the "perform find" feature but it gets stuck at 95 records found and just keeps searching, I waited over 3 days with nothing to show except its helplessl attempt in trying to contiune to perform the find.
I would like to know if there is some way to use a script or portal or something to run a faster find on such a large database.