Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speed of form load in multi-user environment
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01346139
Message ID:
01346248
Views:
11
Try a local copy of the DBC

>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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform