hello,
I have this table to be used in a login system.
it consists of 20 columns (userid, password, security
question, answer, email, mobile, phone, etc)
The last 2 columns are "status" and "activation code".
The activation code is a 48-digit alphanumeric string
sent to new members in an email. When the link is
clicked, users activate their membership. in the
process. the status changes from 'pending' to
'active', and the long code is deleted.
The question is: since the code is only going to be
used once, is it wise to have it in the same table as
explained above?
Would it be better and faster if one created a simple
table of 3 columns, like
userid | status | activation code
which is used solely for the activation process.
The expected number of users is 100,000 and I am just
worried about speed.
Thanks,
David
___________________________________________________________
Yahoo! Mail is the world's favourite email. Don't settle for less, sign up for
your free account today
http://uk.rd.yahoo.com/evt=44106/*http://uk.docs.yahoo.com/mail/winter07.html
