Well, all I can say is "if you find yourself trying to do lots of
joins in Solr, go
back to the drawing board" ;).
Solr is a great search engine, but its ability to be used like a RDBMS
is...er...limited.
RDBMSs are great at what they do, but make pretty rotten search engines.
Rather than think o
Most of the time, the best approach is to denormalize everything into one big
virtual table. Think about a making a view, where each row is one document in
Solr. That row needs everything that will be searched and everything that will
be displayed, but nothing else.
I’ve heard of installations
