This content has been marked as final.
Show 1 reply
-
1. Re: Left-join read-ahead
jobor Nov 25, 2004 5:43 AM (in response to ebu)I'm using 3.2.6. In the example query I always want to read the info of 2 parent EJB's when selecting specific entities. So the query element looks like
<query> <query-method> <method-name>findByNumber</method-name> <method-params> <method-param>java.lang.String</method-param> </method-params> </query-method> <read-ahead> <strategy>on-find</strategy> <page-size>64</page-size> <eager-load-group>all</eager-load-group> <left-join cmr-field = "type" eager-load-group = "all"></left-join> <left-join cmr-field = "archive" eager-load-group = "all"></left-join> </read-ahead> </query>
The <page-size>64</page-size is only useful for loading fields that are not in an eager load group. So in my example the page size is not needed because I have small EJB's with a small amount of entities returned. If you have a large EJB with fields that are not needed then you better do something with on-load, lazy the page size and lazy loading.
Johan.