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
