>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.

I found that you get the best performance if you
- don't use data environment
- initialize tabs as needed (i.e. only initialize the pages whan a user
actually tries to view them)
- open views in the error events - that is views are only opened when needed

This has a dramatic effect on performance (20secs to under 1 sec etc. :) )

Arnon