Suppose I have a user table in my site in which there are around 2-3 Million users (records) in the table.
For speeding up my login process, is it a good approach to split my user table, one for their information and one for their login.
If we can run a query similar to the one below from one table:
select username,password from users where username=`test` AND password=****
Is it necessary to split it, and does this speed up my site's login process?