1 Reply Latest reply on Dec 30, 2003 4:05 PM by julien.dubois

    entity bean on-find optimization

    asanjay

      Hi,
      I'm trying to optimize entity bean access by using on-find strategy in readahead. But instead I managed to degrade the performance. Looking at the documantation I realized that this is because all access to all the entity beans has to be withing a single transaction so that container doesn't have to refresh the data from the database.
      So I created a user transaction before I access the entity beans and then I commit the transaction when I finish, even though it is only a read that I am doing. Is there any way to avoid this?

      Secondly I also realized that while I am iterating over the collection of entity beans that I retrieved, all other clients are blocked till I finish. Is there a way to avoid this too?

      thanks
      sanjay