Should I create two separate methods for fetching records from MySQL database in which one method returns same columns with same conditions but has only one or two columns more than the another one?
For example. Just to view the account information of an employee I write a method
getActiveEmpInfo(String MembId) to fetch employee name, account status, balance. For updating the employee information I have to fetch its all information so I write another method
getActiveEmpAllInfo(String empId) which fetches few more columns like mobile number and address than
getActiveEmpInfo(String MembId) method. so for the difference of two and sometime one column I created another separate method with meaningful name which suits its functionality.
I may have to fetch the record from 4000- 5000 employee rows. Actually it's not just about fetching employee information but also what about queries where I have to fetch sales records of 5 years from 60,00,000 rows( Maximum) from different tables. so
is It good practice to create such separate methods for one or two column differences ?