Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Speed of form load in multi-user environment
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Speed of form load in multi-user environment
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01346139
Message ID:
01346139
Vues:
59
Any ideas on why the speed for a form to open would go from a few seconds to over a minute when a second user logs in?

Norton is not an issue, as I turned it off and it makes no difference.

Any views, are set to not load any data on load. Once form appears, in the init, I populate the one that is for a grid on the form.

Using the coverage profiler, this is the view that slows things done.

All key fields have indexes, all join fields have indexes.

In the load, event I do create a couple of view specific indexes. These however do not effect the timing of the load event.

Mike
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform