James,
I have three related entities say A, B, C with an OneToMany mapping both between A - B and A - C . There is a need to read all the objects in a single query. Therefore i've defined a named query in A as follows:
@NamedQuery( name = "A.findAll", query = "SELECT a FROM A a , hints = { @QueryHint(name = QueryHints.BATCH, value = "a.bs"), @QueryHint(name = QueryHints.BATCH, value = "a.cs"), @QueryHint(name = QueryHints.JDBC_FETCH_SIZE, value = "500") } )
As result I got about 500 objects for A, 5000 objects for B and 50000 objects for C from the three queries (the one named and the two batch queries). Regarding the
tuning of the jdbc fetch size I can only define a single value as query hint as far as I can gather. I take it that it will only taking effect for the A-query wouldn't it? How may I effect then the fetch size for the batch queries. Or, I'm totally wrong here?
--- On Thu, 10/2/08, James Sutherland <jamesssss@xxxxxxxxx> wrote:
From: James Sutherland <jamesssss@xxxxxxxxx> Subject: Re: [eclipselink-users] batch reading with separate fetch size setting To: eclipselink-users@xxxxxxxxxxx Date: Thursday, October 2, 2008, 6:57 AM
I'm not exactly sure I understand what you mean perhaps give an example.
Assuming you want to set the fetch size of the nested batch queries, there is no easy way to do this. However you could prepare() your query, then access the getBatchReadMappingQueries() that are
generated to customize any of the nested batch queries.
Kate Lain wrote: > > Hi, > > > > for performance reasons I've optimized my queries using batch reading > and fetch size tuning - but is there a way to set the fetch size separate > per > batch query? > > Thomas >
----- --- http://wiki.eclipse.org/User:James.sutherland.oracle.com James Sutherland http://www.eclipse.org/eclipselink/ EclipseLink , http://www.oracle.com/technology/products/ias/toplink/ TopLink Wiki: http://wiki.eclipse.org/EclipseLink EclipseLink , http://wiki.oracle.com/page/TopLink TopLink Forums: http://forums.oracle.com/forums/forum.jspa?forumID=48 TopLink , http://www.nabble.com/EclipseLink-f26430.html EclipseLink Book: http://en.wikibooks.org/wiki/Java_Persistence Java Persistence -- View this message in
context: http://www.nabble.com/batch-reading-with-separate-fetch-size-setting-tp19767497p19779803.html Sent from the EclipseLink - Users mailing list archive at Nabble.com.
_______________________________________________ eclipselink-users mailing list eclipselink-users@xxxxxxxxxxx https://dev.eclipse.org/mailman/listinfo/eclipselink-users
|