SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Wizard johnn's Avatar
    Join Date
    Mar 2001
    Location
    Southern California, USA
    Posts
    1,181
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Very simple table design question

    Hi,

    Say I have a table that contains:

    username
    password
    fielda
    fieldb
    ...
    ...
    fieldx

    if I make query to select only username and password and join with several other tables, should I better make a separate table that contain only password and username? Is it more efficient?

    Thanks,
    JOhn

  2. #2
    SitePoint Addict eddiembabaali's Avatar
    Join Date
    Mar 2001
    Location
    USA, Philadelphia
    Posts
    206
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    userid , username, password seems more efficient then you can always use userid to join to other tables
    cd pub \r; more beer

    Eddie

  3. #3
    SitePoint Wizard johnn's Avatar
    Join Date
    Mar 2001
    Location
    Southern California, USA
    Posts
    1,181
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks eddiembabaali, so you recommend making userid , username, password as a separate table?

  4. #4
    SitePoint Addict eddiembabaali's Avatar
    Join Date
    Mar 2001
    Location
    USA, Philadelphia
    Posts
    206
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yes thats what I recommend. I have always used this set up and its never let me down occasional I add a field for permissions (admin, normal, whatever).

    Make it separate table by all means.
    cd pub \r; more beer

    Eddie


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
  •