I will second Javier's comments. I have a six table form that has form calls on buttons in each of the six tables that brings up other forms that have buttons that bring up ... This is the most popular form the users have. Response, although not instantaneous, with six or seven users, is in the "couple of seconds" range. I presented the form in the 2003 (?) conference to demonstrate the use of MDI forms in 6.5++ Windows. It has since moved to 7.1 and added a sixth table to the mix.
--- Javier Valencia <[EMAIL PROTECTED]> wrote: > Marc: > My main menu form calls many forms some will have 4 tables in a tabbed form, > in turn this form can call other forms and so on and you can nest as many as > 10 forms deep and I have not notice performance problems in the newer > computers, the older ones tend to be a little slower. A good database design > is key to good performance; make sure that you define your relationships and > indexes properly and that your network is optimized and you should get good > results. > Javier, > > Javier Valencia, PE > President > Valencia Technology Group, L.L.C. > 14315 S. Twilight Ln, Suite #14 > Olathe, Kansas 66062-4578 > Office (913)829-0888 > Fax (913)649-2904 > Cell (913)915-3137 > ================================================ > Attention: > The information contained in this message and or attachments is intended > only for the person or entity to which it is addressed and may contain > confidential and/or privileged material. Any review, retransmission, > dissemination or other use of, or taking of any action in reliance upon, > this information by persons or entities other than the intended recipient > is prohibited. If you received this in error, please contact the sender and > delete the material from all system and destroy all copies. > ====================================================== > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Marc > Sent: Thursday, August 25, 2005 7:33 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Form limit > > Hi > > I am wanting to use a Menu form based on a > dummy table. This form will have lots of custom > form actions and EEPs stored in the form. > > One of my menu choices will do EDIT USING > formname and this form will have 5 tables in a > tabbed form. > > Will all of the overhead with custom form actions, > and the 5 tables on this form slow down the performance? > > thanks > Marc > > Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
