Alpha Video Training
Results 1 to 7 of 7

Thread: 2 tables open vs 2 table set

  1. #1
    "Certified" Alphaholic Mike Wilson's Avatar
    Real Name
    mike wilson
    Join Date
    Apr 2005
    Location
    Grand Rapids, Michigan
    Posts
    4,201

    Default 2 tables open vs 2 table set

    Good afternoon,

    I am about to begin building an application that is heavily center on employees/ personnel. The main table will be Personnel. This table will contain the unique personnel ID. There will be quite a few tables that are linked to the personnel through the personnel ID, as secondary tables and childs of secondary tables. So far I have:

    Personnel
    -- Orientation Compliance
    =Annual Compliance
    =Job
    =Periodic reviews
    =Salary/payscale
    =Privileges
    =Competancy
    =Qualifications(school delivered)
    =Credentials (professional society delivered)
    =Certifications (government delivered)
    =Continuing education
    etc

    I am trying to be mindful of Dr. Wayne’s insight in not generating a large complex set and break things down.

    http://www.learnalpha.com/SimplifyYo...ifyYourApp.htm

    My question is this:

    Dr. Wayne described independent tables free of being in a set from the original parent (Patients). However, the parent table is still open when he addresses secondary tables (PatIns). What is the difference between having independent tables both open and just a smaller set of two tables, one being the child table?

    Thank you.

    Mike W

  2. #2
    "Certified" Alphaholic Lance Gurd's Avatar
    Real Name
    Lance Gurd
    Join Date
    Jun 2005
    Location
    Southampton, UK
    Posts
    1,441

    Default Re: 2 tables open vs 2 table set

    Mike,

    That has started me thinking in a different way of how to sort out my large cumbersome set of 1 header, 14 children and 1 grandchild that over the network is pretty slow to open, (form with 10 tabs).

    I didn't want to do all that coding as in Dr Wayne's article, this looks like a better prospect. The sets can be defined in no time, then just redesign the form with buttons to open other forms instead of tabs, should be a lot faster.

    Thanks for the idea, will start work tonight and let you know how I get on.

  3. #3
    Volunteer Moderator Steve Workings's Avatar
    Real Name
    Steve Workings
    Join Date
    Apr 2000
    Location
    The Dreaded Chair
    Posts
    5,620

    Default Re: 2 tables open vs 2 table set

    Don't create huge sets, especially on a network.

    The lesson I teach is this:

    Create sets as needed to allow you to construct the forms you need. Don't be afraid to say "Well, I need another set to do that."

    If someone claims they need a form that requires a dozen tables in a set, don't be afraid to challenge them and ask what their work flow etc. is really like. And warn them that, Alpha Five or any other database, will be a bit slow if they insist on that kind of presentation.
    -Steve


  4. #4
    "Certified" Alphaholic Mike Wilson's Avatar
    Real Name
    mike wilson
    Join Date
    Apr 2005
    Location
    Grand Rapids, Michigan
    Posts
    4,201

    Default Re: 2 tables open vs 2 table set

    Lance,
    Your welcome, and good luck!

    Steve,

    Create sets as needed to allow you to construct the forms you need. Don't be afraid to say "Well, I need another set to do that."
    The Personnel table contains the two key fields, Personnel's unique ID (links) and their name. If this Personnel table is placed into many small sets, with the child table being the main activiy table and only needing the unique ID for the link, when all these activities with small sets are taking place on the network, the Personnel table would be open for the term of these activities.

    My exact question is this. These are the posiibilities. Which would be best:

    1. Many small sets with one main parent (Personnel) for all these sets, associated with many different other activities (other tables)?

    2. As Dr. Wayne used in his description, and have both the Personnel table and the activity tables open, the Personnel table open to resource field data from to distribute to the second un-setted activity table?

    3. Or would it be even better to not have a session of the Personnel table open, but open only for moment of a Lookup() using the personnel unique ID for the personnel's name, from a Form based on the non-setted, totally independant and singly opened activity table?

    Asked in another way...

    Is there a greater propensity for conflict attaching one main table to many small sets, being addressed by many activities and many users, or would it be better to have many independant, unsetted tables using either short table open sessions or maybe even better.. Lookups?

    I hope that is decipherable. Thanks

    Mike W

  5. #5
    "Certified" Alphaholic Lance Gurd's Avatar
    Real Name
    Lance Gurd
    Join Date
    Jun 2005
    Location
    Southampton, UK
    Posts
    1,441

    Default Re: 2 tables open vs 2 table set

    What a difference, I was up until 4:00AM getting it as sorted as needed, speed difference a lot better.

    Have given the other users the option on main menu open old form with lots of detail readily available, or open new form with less info but ability to get to other data via dialogs to see how they like it. After all we do design for other users not just ourselves. Plus we can always revert to old form if I have missed anything.

    Must say there is a definate delay on list view dialog showing parent-child data in a two table set filtered on new set structure, but not as slow as it was!!

  6. #6
    "Certified" Alphaholic DaveM's Avatar
    Real Name
    Dave Mason
    Join Date
    Jul 2000
    Location
    Hudson, FL
    Posts
    6,026

    Default Re: 2 tables open vs 2 table set

    I have another question regarding same?

    Is it better to have a main table with 1 child with a lot of fields or
    is it better to have a main table with 9 child tables with a few fields each?

    I have always believed in combining data into 1 table with more fields and I am thinking it as faster. It is not harder to connect and reports are easier.

    Dave Mason

  7. #7
    "Certified" Alphaholic Mike Wilson's Avatar
    Real Name
    mike wilson
    Join Date
    Apr 2005
    Location
    Grand Rapids, Michigan
    Posts
    4,201

    Default Re: 2 tables open vs 2 table set

    Quote Originally Posted by DaveM View Post
    I have another question regarding same?

    Is it better to have a main table with 1 child with a lot of fields or
    is it better to have a main table with 9 child tables with a few fields each?

    I have always believed in combining data into 1 table with more fields and I am thinking it as faster. It is not harder to connect and reports are easier.

    Dave Mason
    Dave,
    I believe opening a table requires more engine than displaying fields. I therefore believe one event that opens 9 tables is more resource hungry than 1 table.
    Mike W
    __________________________
    "I rebel in at least small things to express to the world that I have not completely surrendered"

Similar Threads

  1. Table won't close- Open Tables accumulate
    By Mike Wilson in forum Alpha Five Version 7
    Replies: 6
    Last Post: 09-22-2006, 05:34 PM
  2. Too many open tables?
    By dik_coleman in forum Alpha Five Version 6
    Replies: 8
    Last Post: 11-13-2004, 05:52 AM
  3. OPEN TABLES
    By Walter in forum Alpha Five Version 6
    Replies: 4
    Last Post: 08-16-2004, 05:07 AM
  4. Open Table in a set
    By Ray in forum Alpha Five Version 5
    Replies: 7
    Last Post: 03-30-2004, 06:10 PM
  5. How to know if tables are open ?
    By BDennis in forum Alpha Five Version 4
    Replies: 4
    Last Post: 12-30-2002, 10:58 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •