Cascade indexing issue on creation of new Conference instance (takes >30sec, 70k+ SQLs)
An issue with the search mapping caused an (almost) complete reindex of all conference editions and related data on creation of a new Conference Edition. Debugging revealed that the conference type of a conference edition was indexed for search, while theSubmitted by Elmer van Chastelet on 21 August 2019 at 10:14
ConferenceTypeitself did not have any search fields. Assigning a new Conference to such
ConferenceTypeinstance (e.g. “Conference” or “Symposium”) triggered Hibernate Search to reindex all conferences with that type, which in turn cascaded to other entities like
Profileto be reindexed.
By removing the useless embedded search fields, the issue disappeared.