Thanks. I am on 1.4..so maybe that is the problem. Will try when I get back to work tomorrow. Thanks
Rolf Johansson-2 wrote: > > 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 using cacheKey and cacheLookup instead in something like this: > > <entity name="LinkedCategory" pk="LinkedCatArticleId" > query="SELECT LinkedCategoryBC, CmsArticleId as LinkedCatAricleId > FROM LinkedCategoryBreadCrumb_SolrSearch (nolock)" > processor="CachedSqlEntityProcessor" > cacheKey="LINKEDCATARTICLEID" > cacheLookup="article.CMSARTICLEID" > deltaQuery="SELECT LinkedCategoryBC > FROM LinkedCategoryBreadCrumb_SolrSearch (nolock) > WHERE convert(varchar(50), LastUpdateDate) > > '${dataimporter.article.last_index_time}' > OR convert(varchar(50), PublishDate) > > '${dataimporter.article.last_index_time}'" > parentDeltaQuery="SELECT * from vArticleSummaryDetail_SolrSearch > (nolock)"> > <field column="LinkedCategoryBC" name="LinkedCategoryBreadCrumb"/> > </entity> > > /Rolf > > > Den 2010-01-27 12.36, skrev "KirstyS" <kirst...@gmail.com>: > >> >> Hi, I have looked on the wiki. Using the CachedSqlEntityProcessor looks >> like >> it was simple. But I am getting no speed benefit and am not sure if I >> have >> even got the syntax correct. >> I have a main root entity called 'article'. >> >> And then I have a number of sub entities. One such entity is as such : >> >> <entity name="LinkedCategory" pk="LinkedCatAricleId" >> query="SELECT LinkedCategoryBC, CmsArticleId as >> LinkedCatAricleId >> FROM LinkedCategoryBreadCrumb_SolrSearch (nolock) >> WHERE convert(varchar(50), CmsArticleId) = >> convert(varchar(50), '${article.CmsArticleId}') " >> processor="CachedSqlEntityProcessor" >> WHERE="LinkedCatArticleId = article.CmsArticleId" >> deltaQuery="SELECT LinkedCategoryBC >> FROM LinkedCategoryBreadCrumb_SolrSearch >> (nolock) >> WHERE convert(varchar(50), CmsArticleId) = >> convert(varchar(50), '${article.CmsArticleId}') >> AND (convert(varchar(50), LastUpdateDate) > >> '${dataimporter.article.last_index_time}' >> OR convert(varchar(50), PublishDate) > >> '${dataimporter.article.last_index_time}')" >> parentDeltaQuery="SELECT * from >> vArticleSummaryDetail_SolrSearch (nolock) >> WHERE convert(varchar(50), CmsArticleId) >> = >> convert(varchar(50), '${article.CmsArticleId}')"> >> <field column="LinkedCategoryBC" >> name="LinkedCategoryBreadCrumb"/> >> </entity> >> >> >> As you can see I have added (for the main query - not worrying about the >> delta queries yet!!) the processor and the 'where' but not sure if it's >> correct. >> Can anyone point me in the right direction??? >> Thanks >> Kirsty > > > -- View this message in context: http://old.nabble.com/Help-using-CachedSqlEntityProcessor-tp27337635p27345412.html Sent from the Solr - User mailing list archive at Nabble.com.