Well, you might explain to management that this isn't what Solr is built to do.
12M records is actually quite small by Solr standards. I'd recommend de-normalizing and demonstrating a working solution that uses Solr as it's intended rather than how senior management wishes it were. It'll be a lot easier/faster/more scalable I'd guess. and with 12M records, it will very likely fit on commodity hardware. I'm afraid I can't really help you otherwise.. Best Erick On Mon, May 12, 2014 at 7:21 AM, Aman Tandon <antn.s...@gmail.com> wrote: > Yeah i understand but i got the requirement from the top management, > requirements are: > core1: in this we want to keep the supplier activity points > case 2: we want to boost those records which are present in core1 by the > amount of supplier activity points. > > I know we can keep that supplier score in same core but this requires the > full indexing of 12M records and suppliers are of about 1lacs which won't > cost much. > > With Regards > Aman > > > On Mon, May 12, 2014 at 7:44 PM, Erick Erickson > <erickerick...@gmail.com>wrote: > >> Any time you find yourself trying to use Solr like a DB, stop. >> >> Solr joins are _not_ DB joins, the data from the "from" core is not >> returned (I think there are a few special cases where you can make >> this happen though). >> >> Try denormalizing your data if at all possible, that's what Solr docs >> best... search single records. >> >> Best, >> Erick >> >> On Sun, May 11, 2014 at 6:40 PM, Aman Tandon <amantandon...@gmail.com> >> wrote: >> > please help me out here!! >> > >> > With Regards >> > Aman Tandon >> > >> > >> > On Sun, May 11, 2014 at 1:44 PM, Aman Tandon <amantandon...@gmail.com >> >wrote: >> > >> >> Hi, >> >> >> >> Is there a way possible to retrieve all the fields present in both the >> >> cores(core 1 and core2). >> >> >> >> e.g. >> >> core1: {id:111,name: "abc" } >> >> >> >> core2: {page:17, type: "fiction"} >> >> >> >> I want is that, on querying both the cores I want to retrieve the >> results >> >> containing all the 4 fields, fields id, name from core1 and page, type >> from >> >> core2. Is it possible? >> >> >> >> With Regards >> >> Aman Tandon >> >> >>