>A recent thread talked about performance of opening a form when the form uses views of tables from a network drive.
>A suggestion that came up in order reduce loading time was to set NoDataOnLoad = .T. for each view.
>
>
What if the form is based on tables. Is there a way to optimize the loading of the form?>I have a form that needs 12 tables and it takes approx. 9-10 sec to load when my data is on a network drive.
>
>I took a look to DataEnvironment.OpenTables method and AutoOpenTables property. Can we do something more efficient?
>
>Thanks
>Claude.
Claude,
One way is to open ALL your tables in the default session of your app. Then in your private datasessions for each form VFP uses a USE AGAIN format which is quicker. This puts the heaviest time burden when the EXE starts rather than when each form starts.
A second way is to load your most elaborate forms when the EXE starts, but HIDE() them until they're needed.
HTH
Barbara