>I was thinking of only opening the views/tables when they are required, that is, say, when a pageframe is activated. Is this a good idea, or should the views be left in the DE to be loaded up.

You can make the Views NoDataOnLoad = .F. and Query them when the page they're needed on gets loaded up.

Also, a trick for making the form controls itself faster, is to design the pageframe, then save the controls on each page in a container class, and remove them. When the page becomes active, load the controls programatically.