>I have noticed that my form's instantiation speed is determined by the size of the files in the data environment.
>
>I have a form that has a table with 350,000 records and another table with about 200,000 records. When I issue the do form it takes 15 seconds for the form to load. If I zap these tables then it takes about 4 seconds.
>
>What is happening here? Is there some setting I can set to speed this up. I don't think my customer's are going to find this acceptable.
>
>Thanks,
>Paul

Paul,

In addition to what John & Evan have said I will often use a little psychological 'trick'. I'll put us a WAIT WINDOW NOWAIT "Opening Data Environment, please wait..." fkind of message. Essentially I'm trying to train the user that the behavior is quite normel, because in many cases it is!

I'm probably like every other developer. I want to push the button and have an instantaneous response. As long as there are different kinds of hardware that will not be the case.

In this particular case you may find that your client has a 32MB video card whereas you have a 16MB crd. I'd bet in that case that their response time will be much quicker, so hardware is indeed a factor as well.

Best,

DD