Hi,

I'm trying to improve the performance of a script that sets up a school database for a weekly report. The database is FM 9 DB being run from FM 9 server. The script processes 143 student records and goes through two major sections. The first section checks student attendance and awards a merit for every day the student arrived on time. To do this it uses the number of "on time" days as a loop counter. The loop and creates a merit record for each on time day for the student. To stream line this part I have it do the calculation first then go to the merit layout and create the records. When finished with the loop it goes back to the original layout and continues with the second section of the script

The second section runs through 27 set field steps that update the "static" values that are displayed in the report. The originating fields are active calculation fields that change as faculty add information to the students record. The static values provide a snapshot of the student's record at the time the report is run.
Thus far I have done the following to improve the performance of the script.

1. Set this up so that it goes through the list of students once. (The original broke this up into two sections that each looped
     through the student list. )
  2. Reduced the layout changes to one cycle per student.  This does
     the merit record creation.
  3. Use the Freeze window command before entering the main loop that
     processes all of the student records.  The user sees the list of
     students  and  a flashing hour glass.

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?

Thanks very much
Bruce Herbach




Reply via email to