The password table will contain the member id, the hashed password, and when that password was created. That's it. Only 3 queries will touch that table - getPassword(), createPassword(), and removePassword() which would be SELECT, REPLACE, and DELETE queries respectively. The results will never be cached and they don't need to be since they are only read on login.
The password table will contain the member id, the hashed password, and when that password was created. That's it. Only 3 queries will touch that table - getPassword(), createPassword(), and removePassword() which would be SELECT, REPLACE, and DELETE queries respectively. The results will never be cached and they don't need to be since they are only read on login.