On 12/12/2014 5:16 AM, Tomoko Uchida wrote: > I cannot find out your table structure and Solr schema, > but if your requirement is too complex to handle by DIH, you could handle > it by rich database functionality. > > I think creating a database view is good choice... > > (Of course, other experts may have ideas using DIH?)
Nested entities in DIH work very well, but they tend to have bad performance, because the inner entity's SELECT statement ends up being executed for every single row in the outer entity. Using a database view that does the JOIN on the server side is pretty much guaranteed to have far better performance. Database software is very good at doing joins efficiently when proper DB indexes are available ... the dataimport handler is not. Thanks, Shawn
