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.