It's always a good thing if you can check the debug log (fx catalina.out) or run with debug/verbose to check how Solr runs trough the dataconfig.
You've also made a typo in the pk and query, "LinkedCatAricleId" is missing a "t". /Rolf Den 2010-01-28 11.20, skrev "KirstyS" <kirst...@gmail.com>: > > 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!!!
