AppletTalk.com

visionset · Guest

I have a query where I join 7 tables (4 of which are aliases).
This results in a resultset where there is a huge amount of redundancy.
Now I wish to map this resultset to 3 object Types.
Is the best method to simply iterate over the resultset and build a Set of
each Type.
Due to the redundancy most attempts to add to the built Sets will fail.
I think this will be quickest since it is one query and the reduncancy won't
affect the disk access.

--
Mike W