laker_42 Posted December 21, 2004 Posted December 21, 2004 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
Barbecue Posted December 22, 2004 Posted December 22, 2004 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?
laker_42 Posted January 3, 2005 Author Posted January 3, 2005 The latest updates are installed. It seems to be only this script in this database. John
-Queue- Posted January 11, 2005 Posted January 11, 2005 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.
Recommended Posts
This topic is 7259 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now