Excluding favorited items is an easier problem - get the results - get exclude list from db - scan results and exclude the items in the item list
You'd have to do some code to manage 'holes' in the result list ie fetch more etc. You could marry this with the solr batch based approach to reduce the holes : - Every night, update the item.users field. This can be simple string type of field. - query with negative criteria ie content:search_term AND -users:userid - then do the steps outlined earlier On 5/21/10, Rih <tanrihae...@gmail.com> wrote: >> >> - keep the SOLR index independent of bought/like > > - have a db table with user prefs on a per item basis > > > I have the same idea this far. > > at query time, specify boosts for 'my items' items > > > I believe this works if you want to sort results by faved/not faved. But how > does it scale if users already favorited/liked hundreds of item? The query > can be quite long. > > Looking forward to your idea. > > > > On Thu, May 20, 2010 at 6:37 PM, dc tech <dctech1...@gmail.com> wrote: > >> Another approach would be to do query time boosts of 'my' items under >> the assumption that count is limited: >> - keep the SOLR index independent of bought/like >> - have a db table with user prefs on a per item basis >> - at query time, specify boosts for 'my items' items >> >> We are planning to do this in the context of document management where >> documents in 'my (used/favorited.... ) folders' provide a boost factor >> to the results. >> >> >> >> On 5/20/10, findbestopensource <findbestopensou...@gmail.com> wrote: >> > Hi Rih, >> > >> > You going to include either of the two field "bought" or "like" to per >> > member/visitor OR a unique field per member / visitor? >> > >> > If it's one or two common fields are included then there will not be any >> > impact in performance. If you want to include unique field then you need >> to >> > consider multi value field otherwise you certainly hit the wall. >> > >> > Regards >> > Aditya >> > www.findbestopensource.com >> > >> > >> > >> > >> > On Thu, May 20, 2010 at 12:13 PM, Rih <tanrihae...@gmail.com> wrote: >> > >> >> Has anybody done personalized search with Solr? I'm thinking of >> including >> >> fields such as "bought" or "like" per member/visitor via dynamic fields >> to >> >> a >> >> product search schema. Another option is to have a multi-value field >> that >> >> can contain user IDs. What are the possible performance issues with >> >> this >> >> setup? >> >> >> >> Looking forward to your ideas. >> >> >> >> Rih >> >> >> > >> >> -- >> Sent from my mobile device >> > -- Sent from my mobile device
