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