>Hi,
>
>A customer who is doing beta testing of my application reported a big time slow down every time data is retrieved from the VFP. I believe that the only difference (as far as getting data) is that I added the following code to my function EXEC_SQL_COMMAND() that executes SQL Select. I added this code in order to make sure that the SQL Select opens the right tables in the correct directory:
>
>
>IF AT( CURDIR(), UPPER( cDataDir)) = 0
> *-- Current folder does not match the Location DATA folder.
> *-- Change directory to the DATA folder defined in the preferences.
> SET DEFAULT TO (cDataDir)
>ENDIF
>
>
>Can the above code cause considerable slow down? Interesting thought that when I connect to their server via Remote Desktop and run the application I don't get delay at all.
It may produce a delay especially if this is network folder on a disconnected drive.
If it's not broken, fix it until it is.
My Blog