Hi, what is the default value for org.hibernate.cfg.Environment.MAX_FETCH_DEPTH ("hibernate.max_fetch_depth")?
I'm asking, cause I had huge performance-problems , without it and also with the value of 10. Setting it to 3 or Zero increased performance very much. Also Networktraffic is reduced a lot.
So I wonder what the default value is and why?
Haven't found anything about it yet.
Thanks.
Greetings Michael
PS:
https://www.hibernate.org/hib_docs/nhibernate/html/session-configuration.htmlQuote:
Set a maximum "depth" for the outer join fetch tree for single-ended associations (one-to-one, many-to-one). A 0 disables default outer join fetching.
Eg. recommended values between 0 and 3
But still no hint for the default value.
Is there also an value for one-to-many and/or many- to-many relationships? I want to prevent any join if possible. So that the result of the previous query can be used for the next query, this would reduced the required data to be transferred a lot. Even the numbers of required queries would increase a lot.
But normally the 1:n and n:m should not be nested very deep, so the left outer join may be no huge problem.