Well, you should probably rewrite your app using local views instead of direct access to FoxPro tables. Then when you go to client/server switch to remote views. 600,000 records is not alot for FoxPro but opening a view on a slow network can take some time.
Eric Kleeman - EDS Consulting Services
MCP Visual FoxPro
MCSD C#.NET
Hua Hin Thailand
Los Angeles California