Tony
Tony

Reputation: 38341

Complex Full text search using PlayFramework Search / Hibernate Search

Suppose there are only two type of model objects.

Tag Article

Article can have a variable number of tags, as well as a large text field containing the body of the article.

How do I perform an efficient full text search for articles matching a set of tags that I define? For example, out of 1 million articles, what's the best way to efficiently query (with count and pagination support) for articles that 1) match body:business* and 2) are tag with "America", "Economy" and NOT tagged with "Asia"?

I am able to efficiently do 1) (using HQL or plain old SQL) and 2) (Using lucene query) separately, but not both of them together. Anybody got some ideas?

Upvotes: 0

Views: 862

Answers (1)

Codemwnci
Codemwnci

Reputation: 54884

Have you looked at the Elastic Search module? It is a very powerful module, and the module owner has done a lot of work documenting his work.

Upvotes: 1

Related Questions