Discussions

Performance and scalability: What is best way to compare!!

Bookmark and Share Get thread feed

  1. What is best way to compare!! (5 messages)

    Hi,
    I have two database tables say TAB1, TAB2.
    There are two ejbs for TAB1(EJB1)and TAB2(EJB2). EJB1 gives me a java.util.List of custom Person object. EJB2 also gives a java.util.List of custom Person object.
    List1 and List2 has some Person objects common. I need to compare these two List and need to create a new List which has unique of List1 and List2.
    Can someone tell which is the best way to do this?
    List 1and List2 has more than 3000 Person objects.
    Reply to this

    Threaded Messages (5)

  2. List Algebra[ Go to top ]

    clone listA---calling listACloned

    now listA.removeAll(listB)
    now listACloned.removeAll(listA)


    Answer is listACloned :-)
    Reply to this Reply to original

  3. OOPS[ Go to top ]

    i mis read the question

    just use removeAll on both the lists using the other one
    Reply to this Reply to original

  4. OOPS[ Go to top ]

    I think it should be
    listA.removeAll(listB)
    listB.addAll(listA)
    Reply to this Reply to original

  5. You left the common of both in ListB[ Go to top ]

    :-(
    Reply to this Reply to original

  6. What is best way to compare!![ Go to top ]

    Maybe out of context answer.. but why not simply do that in the DB and use a query/view (using a union-distinct) to publish the list in a new EJB?

    Regards
    Tug
    Reply to this Reply to original