> The problem is that for each record in "fd", Solr makes three distinct SELECT > on the other three tables. Of course, this is absolutely inefficient.
You can also try to use GROUP_CONCAT (it's MySQL function, but maybe there's something similar in MS SQL) to select all the nested 1-N entities in a single result set as strings joined using some separator and then split them into multivalued fields in post processing phase (using regex template transformer or similar)
