I'm not sure of all the details, but you want to use cmp2 and investigate
the read-ahead stuff Dain implemented.  Also you need to make sure your
transactions are large enough to include all the access to the whole
collection.

david jencks

On 2002.04.23 11:08:10 -0400 Frank Morton wrote:
> Using 3.0.0RC1 with PostgreSQL underneath. Just converted
> to using a Local Interface, but didn't make as much performance
> difference as I hoped.
> 
> I have a case where I need to iterate a Collection resulting from
> a finder method with an entity bean. Since the collection might have
> 200 items, performance is very bad iterating the Collection.
> (I do have an index on the field used for finding).
> 
> Using a Collection in the first place is what I would like to do
> since some of the elements require an update. But, since I
> know I will be looking at each item in the Collection, is there
> some way to fetch the content of the collection as a group
> prior to iterating instead of getting killed by the performance
> of fetching one at a time?
> 
> TIA.
> 
> 
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
> 
> 

_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to