Thanks for pointing this out. The wiki had a problem fro a while and we could not update the documentation. It is updated here http://wiki.apache.org/solr/DataImportHandler#cached
On Thu, Jan 28, 2010 at 6:31 PM, KirstyS <kirst...@gmail.com> wrote: > > Thanks, > I saw that mistake and I have it working now!!! thank you for all your help. > Out of interest, is the cacheKey and cacheLookup documented anywhere? > > > > Rolf Johansson-2 wrote: >> >> 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!!! >> >> >> > > -- > View this message in context: > http://old.nabble.com/Help-using-CachedSqlEntityProcessor-tp27337635p27355501.html > Sent from the Solr - User mailing list archive at Nabble.com. > > -- ----------------------------------------------------- Noble Paul | Systems Architect| AOL | http://aol.com