I have rewritten an application from FOX 2.6 Windows to Visual FoxPro 5.0. The rewrite is having performace problems. The detail tables contain 60 to 80 thousand records. The SQL querries choke up the network by pulling the data from the server to the workstation which appears to be the slow down. The rewrite started with views and then changed to accessing the tables directly. The tables are joined with Referential integrity. Any suggestions to improve performance to what the Fox 2.6 for Windows application has?

Thanks.