Is HashSet the best option to process the result of a LEFT OUTER JOIN in the DAO?
posted 7 years ago
I need to perform a LEFT OUTER JOIN (actually two of them) to retrieve all the information I need to return about my "contacts".
As the rs of the query might include multiple records for the same contact (and I might have a rs set of up to 3000 items) what is the best way to process it in my DAO class to return my contact objects?
I do not like to go through a list for every record and check if one with that id is already there. Is HashSet a sensible option? Any suggestion?