SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Zealot
    Join Date
    Aug 2004
    Location
    Utah, USA
    Posts
    110
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Two Tables for Authentication?

    Hi all,

    Some of the sample web authentication setups I'm seeing involve a database with two tables -- one for holding user info like name and phone number and the other for holding username and password.

    There must be a reason for this. Is it a more secure setup?

    Kevin

  2. #2
    SitePoint Guru asterix's Avatar
    Join Date
    Jun 2003
    Posts
    847
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    No it is not more secure, it is faster.

    It is more convenient. Having narrow tables with fewer fields means faster lookups and inserts since lets bytes need to be transferred.

    It is marginal really, IMO it is hardly worthwhile separating just username and password into a separate table.

    I suppose this setup also makes it easier for individuals to have separate login accounts, but i guess that that is rarely needed.

  3. #3
    SitePoint Zealot
    Join Date
    Aug 2004
    Location
    Utah, USA
    Posts
    110
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks asterix,

    Your info helps me better understand what the author might be thinking.

    Best,
    Kevin


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
  •