Just an update for others reading this thread: I had some CachedSqlEntityProcessor and had it addressed in the thread How do I use CachedSqlEntityProcessor? (http://lucene.472066.n3.nabble.com/How-do-I-use-CachedSqlEntityProcessor-td4064919.html)
I basically had to declare the child entities in the db-data-config.xml like: <entity name="Cat1" query="SELECT CategoryName, SKU from CAT_TABLE WHERE CategoryLevel=1" cacheKey="SKU" cacheLookup="Product.SKU" processor="CachedSqlEntityProcessor"> <field column="CategoryName" name="Category1" /> </entity> Thanks to James and others for their help. O. O. -- View this message in context: http://lucene.472066.n3.nabble.com/Speed-up-import-of-Hierarchical-Data-tp4063924p4065400.html Sent from the Solr - User mailing list archive at Nabble.com.