>This is related to thread #
618884 regarding a long-running SQL, but it seems that some of the performance issue is happening when the form opens. I have set NoDataOnLoad to .T. for all tables in the DE and set the AutoOpenTables to .F. also. I put a Set Step On in the form's Init. The form takes almost 2 minutes to open before hitting the Step command. There is no code in the Load event. Any ideas? Thanks!
>
>Regards, Renoir
Init() may be too late. Put the SET STEP in Form.Load(), and before the DoDefault() or scope resolution operator. Then check which commands take so long.
Please note that Form.Object.Init() occurs
before Form.Init(), but
after Form.Load().
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)