>I've a form that performs a data entry function to a parent and child table.
>The datasources are all tied to local views.
>The form as a pageframe with 2 pages and a grid with about 20 columns on it.
>Over a 100mbps network, the form takes about 10-20 seconds to instantiate. From the coverage profiler, I've discovered that it is in the data environment open tables method (where I open all my tables) that is taking the bout of the time. (almost .5 seconds per table with about 16 tables opened). The largest table contain about 30k records.
>I've already created indexes on all the key fields (I'm using surrogate keys to join the parent and child).
>Is there a way to speed things up?
>Thanks in advance
>Yau

Sometimes you need to populate the views later, once the user selects some data, for instance. In this case, it may be superfluous to load the data into the view at form start. Or, you simply want to load the form quickly, and then load the data, for the view, on request (for instance, when the user clicks on a certain page in a PageFrame).

You can avoid the view loading data, changing the property NoDataOnLoad (in the cursor, in the DataEnvironment).