Jump to content

Speeding up Loops


thijorge
 Share

This topic is 5677 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5677 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.