Hi. I use hibernate search 6.1.8. In the fields that I have @Genericfield is it necessary to have an index in the database for better performance both in massindexer and in procedures for updating an object ?
Hey Tony,
Whether the field (column) you are trying to index into a search index has a database index or not doesn’t make much difference from the Search perspective. If you are looking into optimizing the entity loading during the massindexing/updating entity, I would suggest you look at the queries that are executed at that point and go from there (see where you could work on the database schema to improve the results).
See:
1 Like
I have some tables with millions of records. I notice in some processes that I update 3000 at the same time the save is very slow and if I remove the automatic reindex the process ends very quickly and I am looking for a way to solve this problem. I have added index to all the columns that are manytoone and I need them for lucene and I thought maybe I should add index in general to all the columns I use for lucene