[hibernate-issues] [Hibernate-JIRA] Commented: (HSEARCH-521) Improve performance MassIndexer through Eager fetching
[
http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-521?pag...
]
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira