On 2008 Feb 22, at 0:12, Bruce Herbach wrote:
In my test environment this cut processing time from over 3 minutes
to less then 2 minutes. When I ran the original version of the
script in the production environment today it took about 8 minutes
to run. I won't be able to run the updated version in production
until next week.
Does anyone have any suggestions that would help improve
performance of a script of this nature?
By "production environment", do you mean that the files are stored on
Machine A and processed by a user on Machine B? (This is as opposed
to the "test environment", where presumably the files and program are
on the same computer as you, the tester.)
If so, how are A and B connected?
Are they in the same building?
Is FileMaker the foreground application on Machine A?
Are there multiple users in the production environment?
Are you using FileMaker Server?