I think you meant "select session from users where
user_id = 'X'". Anyway, it doesn't matter how big your
table is as long as you build an index on (user_id,
session). This way MySQL doesn't have to touch the
table for this query.
--- Scott Haneda <[EMAIL PROTECTED]> wrote:
> I build a few logi
I build a few login and password systems in MySql, my general layout is as
follows:
Users table and account table. The users table has the bare minimum columns
in it, id, username, password, session, updated, added.
Account table has stuff like first name, last name, email address, street
addres
