[hibernate-issues] [Hibernate-JIRA] Commented: (HSEARCH-521) Improve performance MassIndexer through Eager fetching

[Sanne Grinovero (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-521?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=36831#action_36831 ] 

Sanne Grinovero commented on HSEARCH-521:
-----------------------------------------

this is partly true, I also have experienced an (rather unstable) speedup when eagerly loading one or two relations, but enabling all of them automagically will kill performance on complex models, depends on database, on network, on data. Personally I've selected some properties which are mapped EAGER on the annotations as a temporary solution. Ideally we should use fetchprofiles for this, but that wasn't available when designing this. Help in experimenting with fetchprofiles is now welcome!

> Improve performance MassIndexer through Eager fetching
> ------------------------------------------------------
>
>                 Key: HSEARCH-521
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-521
>             Project: Hibernate Search
>          Issue Type: Improvement
>          Components: engine
>    Affects Versions: 3.2.0.CR1
>            Reporter: Marc Schipperheyn
>            Priority: Minor
>
> The MassIndexer fetches all of a certain entity from the database. It then proceeds to index it and the tree of IndexedEmbedded objects is traversed. In doing so, a lot of additional queries get executed. These queries are not really necessary, since we know beforehand that the data is needed for the indexing operation. So it would make sense to eagerly fetch all associations that are marked as indexEmbedded. This way MassIndexer would significantly speed up.

-- 
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