Re: Help using CachedSqlEntityProcessor

2010-01-28 Thread Noble Paul നോബിള്‍ नोब्ळ्
r" >>>                      cacheKey="LinkedCatArticleId" >>>                      cacheLookup="article.CmsArticleId" >>>       >>> >>> >>> >>> BUT now the index is taking SO much longer

Re: Help using CachedSqlEntityProcessor

2010-01-28 Thread KirstyS
kedCatArticleId" >> cacheLookup="article.CmsArticleId" >> >> >> >> >> BUT now the index is taking SO much longer Have I missed >> any >> other configurationg changes? Do I need to add an

Re: Help using CachedSqlEntityProcessor

2010-01-28 Thread Rolf Johansson
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" : > > Okay, I changed

Re: Help using CachedSqlEntityProcessor

2010-01-28 Thread KirstyS
? 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.

Re: Help using CachedSqlEntityProcessor

2010-01-27 Thread Noble Paul നോബിള്‍ नोब्ळ्
          OR   convert(varchar(50), PublishDate) > >>> '${dataimporter.article.last_index_time}')" >>>                 parentDeltaQuery="SELECT * from >>> vArticleSummaryDetail_SolrSearch (nolock) >>>                                  WHERE conve

Re: Help using CachedSqlEntityProcessor

2010-01-27 Thread KirstyS
;${dataimporter.article.last_index_time}')" >> parentDeltaQuery="SELECT * from >> vArticleSummaryDetail_SolrSearch (nolock) >> WHERE convert(varchar(50), CmsArticleId) >> = >> convert(varchar(50), 

Re: Help using CachedSqlEntityProcessor

2010-01-27 Thread Rolf Johansson
I recently had issues with CachedSqlEntityProcessor too, figuring out how to use the syntax. After a while, I managed to get it working with cacheKey and cacheLookup. I think this is 1.4 specific though. It seems you have double WHERE clauses, one in the query and one in the where attribute. Try

Help using CachedSqlEntityProcessor

2010-01-27 Thread KirstyS
ttp://old.nabble.com/Help-using-CachedSqlEntityProcessor-tp27337635p27337635.html Sent from the Solr - User mailing list archive at Nabble.com.