Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Can fetch size be made to propagate to subqueries made for BatchFetchType.JOIN
Can fetch size be made to propagate to subqueries made for BatchFetchType.JOIN [message #1769861] Fri, 04 August 2017 09:21
Jonathan Lawson is currently offline Jonathan LawsonFriend
Messages: 1
Registered: August 2017
Junior Member
I asked this question on stackoverflowbut without responses as yet: stackoverflow.com/questions/45490459

I'm accessing entities A, each of which has a one to many collection of a few Bs, each of which has in turn a few Cs each of which has a few Ds.

Each of the collections has annotation BatchFetch specifying JOIN, and this seems to work fine, pulling the As, Bs, Cs and Ds in one query each.

Now, for performance reasons, I'm applying a hint for JDBC_FETCH_SIZE to the query on A. This seems to work for A, but the automatically generated sub queries for B, C and D appear to use the default fetch size of 10, which is a performance bottleneck.

Am I right that this is the likely explanation of the subqeries taking much longer than the main one, despite pulling roughly the same amount of data?

Is there any way to persuade eclipselink to use the larger fetch size for the subqueries too?

Any other suggestions?
Previous Topic:How to close entity manager/ DB connection / unit of work when EntityFetchGroup is used
Next Topic:Cannot remove an entity with @ManyToOne association without fetching its contents
Goto Forum:
  


Current Time: Mon Dec 11 09:41:22 GMT 2017

Powered by FUDForum. Page generated in 0.01327 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software