I'm indexing 80K + entities and doing things pretty much by the book as described in the Hibernate Search in Action book.

I am unable to make use of @Batch or @Subselect however since it has negative impact in other areas of the application. I am however using the fetch join to eager fetch all the @IndexedEmbedded values

Would doing projection or does anyone else have any other recommendations on to increase performance? As it is now the expectation is that for this particular entity we may have around 200K and based on my timing it would take close to an hour to batch which is not acceptable.

Thanks

most of the time if indexing is slow it's because the queries to load all the data are too slow.


It is possible that this is making performance worse, try removing some fetch join rules: if you are joining more than one table the database resultset is going to grow quite fast.