Just out of curiosity why do you have 26 columns? I presume you're also storing data like first_name, last_name, address, country, etc? I am too, but I cleverly have a user_meta table that allows dynamic user meta values. Your approach is probably faster because you're not joining any other tables.
2 comments
[ 0.26 ms ] story [ 13.5 ms ] threadID, username, password, email, last_login, role_id, status, auth_code, remember_me
Just out of curiosity why do you have 26 columns? I presume you're also storing data like first_name, last_name, address, country, etc? I am too, but I cleverly have a user_meta table that allows dynamic user meta values. Your approach is probably faster because you're not joining any other tables.