[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5686) Collections should be loaded by default using "lazy collection fetch" instead of "extra lazy collection" fetch

Emmanuel Bernard (JIRA) noreply at atlassian.com
Thu Oct 28 05:27:48 EDT 2010


    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=38900#action_38900 ] 

Emmanuel Bernard commented on HHH-5686:
---------------------------------------

Not sure I follow you. Can you attach a test case with your mapping?

> Collections should be loaded by default using "lazy collection fetch" instead of "extra lazy collection" fetch
> --------------------------------------------------------------------------------------------------------------
>
>                 Key: HHH-5686
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5686
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: envers
>    Affects Versions: 3.6.0
>         Environment: Works fine with in-memory database like H2 but for MySQL5 generates too many queries. 
>            Reporter: Srinivas Nandina
>            Priority: Minor
>
> If an entity has a collection (either entities or components), then loading the collection from audit tables one query is issued per element of collection rather than issuing one query for the whole collection. Because of this while loading huge object graphs from audit tables, large number of queries are issued and taking long time to load the data.
> Default option to load collections should be changed from "extra lazy collection fetch" to "lazy collection fetch".
> More details can be found at the discussion in the forum:
> http://community.jboss.org/message/567086

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        


More information about the hibernate-issues mailing list