Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    Regular Coder
    Join Date
    Dec 2005
    Posts
    217
    Thanks
    1
    Thanked 0 Times in 0 Posts

    more than 50 fields in a table ??

    Hello forums!!
    I had made a table which contains more than 50 fields..
    I am afraid this will hamper later ..

    What i want to know ?
    1>how many fields should be in a table for optimization ?
    2>what should taken into consideration for future hazards in case there are more than
    50 fields in table ?

    I would really appreciate the answers from you
    Thanks in advance to all of you !!

  • #2
    Senior Coder NancyJ's Avatar
    Join Date
    Feb 2005
    Location
    Bradford, UK
    Posts
    3,172
    Thanks
    19
    Thanked 65 Times in 64 Posts
    Have you considered whether normalisation is an option? What are the 50 fields, I cant think of many situations where I would need 50 fields in a single table.

  • #3
    Master Coder felgall's Avatar
    Join Date
    Sep 2005
    Location
    Sydney, Australia
    Posts
    6,611
    Thanks
    0
    Thanked 645 Times in 635 Posts
    Usually normalizing the table to at least third normal form should produce the optimum arrangement of the data into tables. 4th, 5th, and Boyce-Codd normal form only apply in certain situations anyway while the first three normalizations always apply.

    There may be rare occasions where you undo a small part of the normalization and duplicate data to significantly speed up processing.

    It would be just about impossible to have a situation where normalizing the data will leave you with anywhere near 50 fields for the same table. In most cases where you have that many fields there will either be repeating groups or cross field dependencies to be normalized out into separate tables.
    Stephen
    Learn Modern JavaScript - http://javascriptexample.net/
    Helping others to solve their computer problem at http://www.felgall.com/

    Don't forget to start your JavaScript code with "use strict"; which makes it easier to find errors in your code.


  •  

    Posting Permissions

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