Speeding up Loops

[thijorge]

Hello Everyone!

I am having issues using Loops on my program.

It turns my program really slow.

I will place some numbers to make sure it is slow and it is not just me being impatient.

In a sample with 32 Students that answer to 54 questions, therefore the table TEST_RESULT has 1728 records (32 x 54). The scripts take roughly an average 35 seconds to execute.

The Loops are either by student (32 times) or by questions (54 times) and sometimes there is another variable involved.

I tried using Freeze Window but sometimes it is still possible to see the scrollbar flicking.

Are there any other suggestions to make my program run faster?

Some of my Loops call a Custom Function, so I am not sure if the Custom Function or the Loop is being the bottle neck.

Thanks,

Thiago

[Fenton]

The essential step to speeding up a Loop is to be on, or switch to View as Form. Freeze Window also helps; but, as you say, the scroll bar flickers when in List View, and this slows FileMaker down. Other than that it's up to whatever it is you're doing.