0 Replies Latest reply on Feb 1, 2006 8:57 AM by Fabio Retzlaff

    Removing large amount of Entity Beans

    Fabio Retzlaff Newbie

      I would like to know if is possible to optimize the remove process of a large amount of EJBs.
      We need to remove the old data of our database but the performance of this operation is bad because we make a find method to bring these data and do a loop over the result removing the entities but the entity bean have a relationship with another entity bean. Ex:

      OrderEJB -> ItemEJB

      What happens is a loop over the collection of orders and a loop over the collection of itens of the order to remove each one. This executes one delete comand to remove each entity and this execution takes a lot of time.

      Anybody knows how I can optimize this??