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 ?
Being Java programmer.
The longest recorded flight time of a chicken is 13 seconds. But that was done without this tiny ad: