>>>I have a VFP9 app that runs against Sql Server. When I runs the forms from the FoxPro IDE, running against the same Sql Server database which is located on a central server down the hall (i.e. NOT on my local developer machine), all the forms load up and run very quickly.
>>>
>>>However, once compiled into an exe, and runnging the compiled exe from by same devloper box (outside of the FoxPro IDE), the forms take about twice as long to load up. This is very consistent across all forms.
>>>
>>>Is there particular reason that forms would run more quickly inside the FoxPro IDE than when compiled into an EXE?
>>
>>You would need to get all settings from IDE and compare with all the settings in run-time. Some of the settings don't match and cause the slowness.
>
>
>>> Some of the settings don't match and cause the slowness.
>
>Any ideas on which ones you might suspect the most?
Hard to say, actually. The ones dealing with connection and may be SET ANSI.
>
>And, where would I change them for the running exe?
In the main program of the application and in the base form class Load method.
If it's not broken, fix it until it is.
My Blog