>I have a formset that loads about 6 tables and 4 views. I find the loading slow. Any suggestion on how to speed up the loading?
>
>I have already set NoDataOnLoad=.T. in DE. I am running Private data session. Not all the tables and views are always needed. Some of them are needed for instantiated objects.


There is a whitepaper on the VFP website (http://www.microsoft.com/vfoxpro) that discusses optimizing your application.
It was written for VFP 3.0, but much of it applies to VFP 5.0 too.