> tables. Others are suggesting 2 separate indexes on 2 different machines and > using SOLRs capacity to combine cores and generate a third index that > denormalizes the tables for us.
What capability is that, exaclty? I think you may be imagining it. Solr does have some capability to distribute a single logical index across several different servers ("sharding") -- this feature is mainly intended for scaling/performance, when your index gets too big for one server. I am not quite sure why it's so popular for people to come to the list trying to use sharding (or a mythical 'capacity to combine cores' which isn't quite the same thing) for entirley other problems, but it usually leads to pain. What problem is it you are trying to solve by splitting things into separate indexes on two differnet machines, and then later generating a third index aggregating the two indexes? I suppose you _could_ do that, first index into two separate indexes, and then have an indexer which reads from both of those two indexes, and adds to a third index. But it wouldn't be using any 'capacity to combine cores' -- and I don't believe there is any such 'capacity to combine cores' in such a way to somehow automatically build a third index from two source indexes with an entirely different schema that somehow manages to 'denormalize' the two source indexes. What are you trying to accomplish that makes you imagine this?