I have a Batch Tracking database that I just upgraded to FMP 7. The actual database is living on a FMP 7 Advanced server. This one particular script is running significantly slower now in FMP 7. There isn't much to it so I don't understand why. The database tracks mail batches that are assigned to processors. This script allows the users to assign multiple batches to 1 person without manually creating each new record. Here is the script:

loop

Exit if[isEmpty(NoOfBatchesToCreate)]

Exit if[NoBatchesToCreate = 0]

Duplicate Record/Request

Insert Calculated value(NoBatchesToCreate;NoBatchesToCreate -1)

End loop

Does anybody have any ideas what might be going on? Do I need to tune some settings on the server? Any help would be appreciated!

Thanks!

John

Have you installed the most recent FileMaker updates?

http://www.filemaker.com/support/updaters.html

Is it only this one script that's slow, or is it just that the problem is more noticeable with this script?

The latest updates are installed. It seems to be only this script in this database.

John

Change your Insert to a Set Field step, make sure the layout is set to View as Form, and that you are freezing the window before the loop. Does that help any?

How many auto-entered fields do you have and are there any that reference related files? If so, File References may need some cleaning.