Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Slow performance on server
Message
 
To
24/06/2013 18:20:20
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01577003
Message ID:
01577039
Views:
84
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform