Reputation: 38341
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
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