Okay, I changed my entity to look like this (have included my main entity as well): <document name="ArticleDocument"> <entity name="article" pk="CmsArticleId" query="Select * from vArticleSummaryDetail_SolrSearch (nolock) WHERE ArticleStatusId = 1" <entity name="LinkedCategory" pk="LinkedCatAricleId" query="SELECT LinkedCategoryBC, CmsArticleId as LinkedCatAricleId FROM LinkedCategoryBreadCrumb_SolrSearch (nolock)" processor="CachedSqlEntityProcessor" cacheKey="LinkedCatArticleId" cacheLookup="article.CmsArticleId" </entity> </entity> </document>
BUT now the index is taking SO much longer!!!!!!!!!!!!!!!! Have I missed any other configurationg changes? Do I need to add anything into the solfconfig.xml file? Do I have my syntax completely wrong? Any help is greatly appreciated!!! -- View this message in context: http://old.nabble.com/Help-using-CachedSqlEntityProcessor-tp27337635p27353768.html Sent from the Solr - User mailing list archive at Nabble.com.