>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.
Ensure you dont have any indexes on DELETED in your tables.
Ensure that you dont have any indexes on fields that would just separate the data into halves or thirds or fourths. An example of this would be an index on Sex where the only choices are M or F.
Just a couple of things off the top of my head.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope