At 03:25 PM 1/13/2015, [email protected] wrote:
This is a new form and is somewhat complex. It has an enhanced Tab control
with 12 tab pages. Each tab has a variable lookup list view. So the question
is why 5 seconds to start with few users connected and 6 times as long when
several users (sitting idle) are connected? Why would only the startup speed
be affected?
Thoughts anyone?
Bob,
If you didn't know already, every control, including the population of the
lookup data in Combo Box, List Box, and List View is evaluated based upon
the WHERE clause before the form is completely drawn (displayed).
In your specific situation, having the Enhanced Tab Control with 12 pages
and 12 different Variable Lookup List View controls on each page is the
cause.
Technically, the user can only see one page at a time. Correct?
Why create such overhead up-front?
I suggest to re-evaluate your way of designing forms and providing users
the necessary data they need to view. After the first page data is displayed
accordingly, all subsequent pages and related data (pages) should be
displayed on demand as a separate form that looks like a Tab Page and close
that page when done. That way you start with only one form with one Tab Page
and all other simulated forms (Tab Pages) may be called on demand when
necessary.
Designing a swift form with all the functionality is an art and requires
some thinking and re-evaluating the entire process.
Hope that helps!
Very Best R:egards,
Razzak
