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
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.
"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