Authentication

Question

When doing user login authentication is retrieving the user name/ID and password nd doing validations locally better than retrieving the row count.?

Answer 1

Those are two completely different functions.

What you should be doing is encrypting all passwords and adding a salt (perhaps use the username for this) and save the user's login to a database as the encrypted password hash. When user logs in you would compare the login hash with the hash in the database.

There are many ways to validate as well... if this is a Web app you're working on then do both front end and backend validation.