>Does any of this take place across a network, or is the ASCII file and the destination tables on the same machine?
The application is running on an NT network. Running the application locally is only about 10 - 15% faster. The application does not seem to generate a lot of network trafic.
>
>What about increasing the memory from 64MB? VFP is a memory hog. Is anything else taking up memory when this application is running?
This will be one of my recommendations. When I double the RAM and CPU I get double the performance.
I found a locate in the code that is taking .03 secs. I am changing the logic so I can use a seek. The seek seems to be taking about .002 secs. This one change is doubling the performance. I am going to continue reviewing the code. The problem is there are a couple hundered lines of code with each line taking .0008 secs. Not sure what else I can do except try to change the logic to eliminate more code. Still working on it....
Shane Murdoch