General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Speed of form load in multi-user environment
Environment versions
Network:
Windows 2003 Server
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only