Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Slow performance on server
Message
 
À
24/06/2013 18:20:20
Mike Yearwood
Toronto, Ontario, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01577003
Message ID:
01577039
Vues:
83
>Do you hard code pathing inside your code? Do you say do form d:\blah\somefolder\yourscreen.scx in the code in your production exe? If so, vfp is attempting to look there for the form. Inside your exe, your code does not need such pathing. You can also use sys(2450,1) to force it to look in the exe first. You only need a path to the form at design time during design-time testing in the IDE. At runtime, you only need a path to the data folder and possibly image folders. I open all tables at app start. Subsequent USEs inside private data session forms and also subsequent SQL queries benefit. That is because they basically do a USE AGAIN which is fast on an already open table.

Thanks, Mike. No, I don't specify path inside programs. Everything's in one exe (around 13MB total). There's only one PATH statement in config.fpw (made sure it's all valid), and that's it. And yes, I leave most frequently accessed tables USEd at run-time.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform