Alpha Video Training
Results 1 to 5 of 5

Thread: More Tables or Less?

  1. #1
    Daryl Strickland
    Guest

    Default More Tables or Less?

    I am starting a new database from scratch and pondering on ways to make it more efficient. One thing I am wondering is, is it best to use more tables or less? Example: My old database customer table has fields for phone, fax, email and zip code. Would it be best to create separate tables for those fields? My thinking is I could then use those tables to link all tables that have phone, fax,email and zip code fields. So, if I use more tables will it slow down my database and or cause a linking nightmare.

    Thanks,

    Daryl

  2. #2
    "Certified" Alphaholic forskare's Avatar
    Real Name
    Ken Nordin
    Join Date
    Apr 2000
    Location
    Walker, MN
    Posts
    7,545

    Default RE: More Tables or Less?

    One way to make this determination is to look at AlphaSports, the app that ships with A5. How did the pros at Alpha do it???

    kenn

  3. #3
    "Certified" Alphaholic
    Real Name
    jim chapman
    Join Date
    Apr 2000
    Posts
    1,779

    Default RE: More Tables or Less?

    Hello Daryl,

    >>Example: My old database customer table has fields for phone, fax, email and zip code. Would it be best to create separate tables for those fields?

  4. #4
    Daryl Strickland
    Guest

    Default RE: More Tables or Less?

    Thanks Ken and Jim for the response. You reaffirmed the KISS (Keep it simple stupid) approach that is best or me because of my limited knowledge.

  5. #5
    "Certified" Alphaholic forskare's Avatar
    Real Name
    Ken Nordin
    Join Date
    Apr 2000
    Location
    Walker, MN
    Posts
    7,545

    Default RE: More Tables or Less?

    Daryl,

    Don't be shy about asking for help no matter how dumb you think the questions is. We've all been there. Ha, I still am! (:>}

    kenn

Similar Threads

  1. No of tables
    By Robin Smith in forum Alpha Five Version 5
    Replies: 4
    Last Post: 04-21-2005, 05:22 PM
  2. Tables With Two IDs
    By George Smyth in forum Alpha Five Version 6
    Replies: 2
    Last Post: 01-13-2005, 12:00 PM
  3. appending tables
    By Bob Burnside in forum Alpha Five Version 5
    Replies: 1
    Last Post: 07-12-2004, 12:28 PM
  4. Many tables into one
    By MIKE LYON in forum Alpha Five Version 4
    Replies: 5
    Last Post: 06-24-2002, 05:10 PM
  5. How many tables can you put in in adb?
    By DaveM in forum Alpha Five Version 4
    Replies: 5
    Last Post: 10-11-2001, 05:51 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
  •