Hello,

I am adding on hibernate search to an existing database with a large amount of data. The ultimate front end concept is to have a search box where users can query anything in the database. This spans several entities (about 30). I am trying to narrow the pool of entities that get searched and then returned to the user on a results page. My initial thought was to query each entity for the first 20 results I get back, and then order the entities by the sum of the 20 results' score. I would then get the full results from the top 3 entities and aggregate them to be displayed to the user. If the user wants to broaden their search, the page displays the next top 3 queries and so on.

I am fairly new to hibernate search, so I am not sure if this is a good idea at all, or if anyone has done something similar in a way that would better. Any input would be appreciated.

Thanks.

Hi,
for what reason are you narrowing down the selection of entities? Why not let the user search across all of them directly?