Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Slow respones out of an application
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement