Even if I had ONE lookup listview With a where clause (or a lookup for any control with a WHERE) I would employ Dan's method. In your case, if each of the lookups is over a small dataset, then I doubt that changing from tab to tab would produce a (user) noticeable difference, in any case in subsequent changes, you would be at your endgame scenario that you have described. So what would be the harm and it looks like the upside would be worth it..
And Bob, in the length of time you took to write your email, you could probably have set those lookups on a test (copy) of the form to Limit=1 just for S&G. > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of > [email protected] > Sent: Tuesday, January 13, 2015 5:28 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: Form startup speed / network > > Thanks for the feed back everyone. > > > I may have been a bit unclear, in that there are 12 tab pages but only > one list view on > each page. The data set quite small, about 4000 rows. One would be > hard pressed to > have a better designed form for what this situation requires. > > In this case, I am willing to wait the 30 seconds to start the form as > once it is started, > the users can instantly move from one tab to another and do so for many > functions. This form > is designed to be a "work station" where the user stays for hours at a > time. > Each tab has information that is needed and needed quickly, so the user > flips back and forth between tabs continuously with a single click, and > in the present case instantly. > They select information from the list views and then many other > functions can be conducted via various button eeps and so forth. The > only data shown on this form is the list views, but it is the "traffic > control center" of the operation. The form works perfectly once > started and the users are extremely happy. > > > Since this is a "work station" form and the user will be in this one > form for hours at at > time, taking 35 seconds to start is minor compared to the superior > efficiency and > functionality they are getting with the present design. So no need to > rebuild Rome in > > this case. > > > As often, I try to understand the logic and working functionality of > anything I do. This helps > me insure that I design and code the best system I can, both now and in > the future. My apologies > if my question was misunderstood. I do not need to know how to make > the form better, > I was interested in determining what causes the form to start in 5 > seconds in one case and > 35 seconds in another case. This information is important to know for > me for future coding. It is > always best to know what to do and why you are doing it in my opinion. > I do not like doing rewrites > and doing it right the first time is how I strive to function. I find > a good understanding of the under > lying principles is what makes me efficient. Thus my question > > > To my understanding, the form would be in a read only mode when > starting up as far as the data set. > (There are no editable fields in the list views) I was surprised to > see the large difference in start up speed when 4 users were connected > to the database versus 30 and was inquiring on why that might be the > case. Not that 30 were using the form, but setting idle and only one > session starting the form. > > > Anyway, thanks again. > > -Bob --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=
