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
>> >>
>>
