On Mon, Dec 22, 2008 at 11:52 PM, KishoreVeleti CoreObjects < kisho...@coreobjects.com> wrote:
> > Suppose say if a term matches more than one answer_id BUT question_id is > same then I should return only one question though it matches more than one > answer_id. This is because I have to show only question in the UI (search > results page) with a link to view all Answers for this question De-normalize the tables into a single Solr schema. So your schema.xml will have the question_id, question_title, question_description, question_category and a multi valued field for answer_description. > After findin the unique question ids from SOLR I need to fetch additional > data from the database no of times a question is viewed by users in search > results page, no of times a question full_details_page is viewed by the > user, no of times a question is appeared in the search_results page > You can also store enough information in Solr to display the search results page. You may not need to hit MySQL for every question_id returned in the results. > -- > View this message in context: > http://www.nabble.com/SOLR-in-PHP-for-my-web-application-tp21132500p21132500.html > Sent from the Solr - User mailing list archive at Nabble.com. > -- Regards, Shalin Shekhar Mangar.
