CMP Query and Load Optimization

jmntn2000 Jul 19, 2004 12:23 PM

Hi,

I am trying to optimize the CMP queries and load groups for my application. It all seems to be working fine except for the following areas:

1) I can't get the CMP engine to use a load group with on-find for loading relationships or findbyprimarykey? How do I specify these? This question may be more for the CMP group but though I would try here first.

2) When you specify a relationship accessor in a load group, jboss still does two queries to fetch the data although it seems to preload it. Is there a way to force the container to load the primary bean and the related bean in one query? This would be a lot more efficient in terms of database usage.

Thanks.
James

1. Re: CMP Query and Load Optimization

aloubyansky Jul 20, 2004 1:58 AM (in response to jmntn2000)

Preloading CMR and CMP fields in finders using on-find is covered in on-line docs.
1) ejb-relationship-role has optional read-ahead child. The same for query element.

2) have a look at http://www.jboss.org/wiki/Wiki.jsp?page=LeftJoinReadAhead
Actions
2. Re: CMP Query and Load Optimization

jmntn2000 Jul 20, 2004 11:32 AM (in response to jmntn2000)

Thanks that is exactly what I was looking for!
Actions

Go to original post