Thank you for your post.
There are a lot of factors when using FileMaker Pro. If you are manipulating/changing data in your database, then the speed of your hard disk can play a role. However, most of the If you are manipulating data, the speed of the hard disk is important. And yes, FileMaker Pro is CPU intensive.
If you execute a script, FileMaker Pro will reserve one of the "cores" for the script itself, so only one core is used.
I know you said you have "a lot of recursive operations". Is it possible to put any of this information into a calculation field? This may help reduce the number of recursive operations, and as a result, reduce the amount of time the script runs.
If you want to give us an idea of what you are doing, perhaps someone can offer a different way of looking at the situation and provide a different solution.
The general process was detailed in a message that I posted on 10/25/2008. That is around page 53 of the forum now. Basically I need to do a lot of number comparisons in a database and it is taking a long time. I have tried to script the searches atleast 5 different ways and the searching is always around the same time. I made an executable file and tested it on a number of different computers with different configurations and the only factor that made the process faster was higher CPU clock frequency. The size of the data is quite small since it is just a set of numbers. RAM drives or RAID 0 configurations did not improve the performance.
If you have any ideas on a way that a calculation could help that would be greatly appreciated.
Thanks for the information about the original post.
Have you tried a relationship into the same file? This would help narrow down the search times. You can link the first set of numbers to the first set in the first table occurrence, the first set to the second set in the second table occurrence, the first set to the third set in the second table occurrence, etc. This seems like it would cut down on the time, because the Find is already set up.
What happens when you try this approach?