sanne.grinovero wrote:
That looks like an improvement we could make. So you expect to run the MassIndexer regularly in production? Shouldn't be needed generally.
If you allow Hibernate to manage the insert/update/deletes from the database, absolutely. But in the cases where the data is managed outside of Hibernate and all Hibernate offers is a database agnostic solution for a web application that has read only access to this information, then the MassIndexer appears to be the only viable way to keep the Lucene indexes aligned with the data in the database.
I have considered moving the TSQL programs from the database into Java-code that leverages Hibernate in the long-term but we have some prior milestones that must be met before that can be made a reality and some research needed to manage Hibernate connected to multiple databases.