>In prior versions (2.6 and below), one way to speed the loading of the forms and processing of procedures was to keep the tables open in all previous USE's so it doesn't have to reopen everytime a form/routine is run. Now in Visual Foxpro with use of private datasessions, would setting the AutoClose property of the DE to .F. accomplish a similar results? I know each private datasession uses a separate data set but it's hard to believe there would be no difference at all. Any insight??
>
>TIA
>John.
Setting autoclosetables to .F. with private dasessions has no real effect because the datasessoin that the table was open in is destroyed anyway.
I have been told that opening all tables at app.init will speed form loading, because it forces the form to effectively use "USE AGAIN" instead of just 'USE', and 'USE AGAIN' is faster. But I have tested this on my main app (80+ tables), and saw very little (no significant) effect on form loading speed, nowhere near enough to add the 20 or so seconds that it took to open all the tables at the beginning of the app.
Erik Moore
Clientelligence