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
Title:
Speed of form load in multi-user environment
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01346139
Message ID:
01346139
Views:
58
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
Next
Reply
Map
View

Click here to load this message in the networking platform