Since you're using MaxFrame make sure the setting to auto-open the tables at the front of the application is happening. As far as the view's go, maybe play around with the parameters of where it's actually being requeryed...make sure you have an index set for the field you're actually using as a parameter.
The only other thing is to ax the data-enviornment all together and manually do it all in the load() event of the form. I noticed you said you had a lot of tables in the DE and didn't really want to do all that...but...if you have several forms that are using the same type of DE....you might be able to write a .prg to do it..thus saving you recreating the DE again for another form. If this is the case...in the long run it might actually save you time.
Also...which verson of VMP are you using?
Good luck...


>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