>>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.
What do you mean by "disconnected" drive?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham