1 Reply Latest reply on Jul 11, 2004 4:32 AM by aloubyansky

    EJB QL performance

      Hello all,

      I have a find method in an entity bean that returns 4 references. In a session facade the initial findAllXXX takes 2 seconds. Then a transfer object is created for each eb. On the eb 5 get methods are called. in this loop over the 4 results, the calling of the get method takes 12! seconds (for each object so in total almost 1 minute). It seems that for each get the object is again fetched from the database. Is there a way to get around the loading of each seperate entity bean.
      E.g what I would like is that the entity bean with fields A, B, C, D, E has a findAllXXX method that returns a Collection with for example collections that contain A,B,C,D,E directly coming from the query instead of from the entity bean. Is this possible using CMP?

      Thanks in advance,

      Rein