> Does anyone have an entity bean that has a method that > returns a Collection that performs well with ~200 elements > in the Collection? Reaching it through a session bean is > fine. If so, would you share the source? I'm beginning to > believe that no one actually has done this successfully.
Yes, I have run into the same issue using a custom finder. One finder in particular returns all order lines for a customer. This is very quick if a moderate amount of records, but because agonizingly slow when it gets into the hundreds. The custom finder SQL is tuned and tested so I know the PK values are coming back quickly (single column PK). I was thinking of doing some timing tests to see where the issue is. Sounds like you have already done this. I wonder though what the time is to load a bean found by PK rather than the finder collection is. It shouldn't be different, but if it is then that would give us more information. I know other beans that I find by PK load up much faster than 100ms. I am still on 3.0.0beta, but we seem to have the same issue anyway. _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
