strange performance

S

Shirley

I have a form which contains three sub forms. The main
form gets data from local computer and all sub forms from
server.

The first time I put the LinkChild and LinkMaster
elements in form design. It took a pretty long time to
open this main form -- guess the reason is that the sub
forms need to get data from server.

To improve the performance, I deleted the LinkChild and
LinkMaster in form design, which means when running the
main form, all sub forms will have to load all data from
server since there is no data link between the main form
and the sub forms. Then I set the Timeinterval in main
form to be 1, add an action to On "Timer". In this
action, I set the LinkChild and LinkMaster to all three
sub forms, and of cause also set the timeinterval to be
0. After this change, the performance improved
dramtically.

First question, why did this change improve the
performance? Sounds unexplainable.

I have another form where I need to go the main form
mentioned above to a specific record. Now it takes pretty
long time to open the main form after the change above.

So the second question, why? Any other ideas to improve
the performance?

Thanks a lot!

Shirley
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top