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-tp27337635p27337635.html
Sent from the Solr - User mailing list archive at Nabble.com.
