Can Solr Improve Social Responses?

Question

I am trying to sort the results based on the like number .

The most obvious solution is to have a like field for each line and reindex the document for each user who clicks like. But reindexing large documents in this case is impractical.

---

(below for example: no large documents)

Ideally, I would like to index both data and user actions in Solr as separate lines.

Lines (as shown below) are relatively stable over time.

id:place_1 title: ela restaurant meta: sea food, chinese food festival description: this place... 

Action lines inserted every time the user clicks “like”.

 id:action_43141 action:like user:john target:place_1 id:action_44323 action:like user:doe target:place_1 

---

How can I increase the result based on the number of likes , given that each of them exists on its own line?

---

I know that in the upcoming Solr 4.0 http://wiki.apache.org/solr/Join there are associations. But will it improve estimates based on the number of matching rows?

Answer 1

Take a look at ExternalFileField . There is not much documentation at the moment, but watch this presentation .

Answer 2

Also take a look at the click relevance rating presentation