Hello I have a (JSE) desktop application. A number of instances connect to the same database.
The user wants a full text search (over many db fields).
Is it practicable to use Hibernate search for this? I would have to build the indexes at every startup. And of course update of one user would not be visible in the indexes of another user during runtime (I think this would be only a minor problem). Is it possible to store the indexe in the database itself? Would that harm performance?

Hi,

One option e.g. would be to use the JMS backend which will route all index updates from all your clients to a single master that does the actual index write. Then use the directory implementation which copies index data regularly to slaves (filesystem-master/filesystem slave) or the Infinispan directory implementation which will make index changes instantly visible to all nodes.

Take a look at the sections "worker configuration" (https://docs.jboss.org/hibernate/search/5.5/reference/en-US/html_single/#configuration-worker) and "directory configuration (https://docs.jboss.org/hibernate/search/5.5/reference/en-US/html_single/#search-configuration-directory) in the reference guide.

Hth,

--Gunnar