r"
>>> cacheKey="LinkedCatArticleId"
>>> cacheLookup="article.CmsArticleId"
>>>
>>>
>>>
>>>
>>> BUT now the index is taking SO much longer
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
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
?
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.
OR convert(varchar(50), PublishDate) >
>>> '${dataimporter.article.last_index_time}')"
>>> parentDeltaQuery="SELECT * from
>>> vArticleSummaryDetail_SolrSearch (nolock)
>>> WHERE conve
;${dataimporter.article.last_index_time}')"
>> parentDeltaQuery="SELECT * from
>> vArticleSummaryDetail_SolrSearch (nolock)
>> WHERE convert(varchar(50), CmsArticleId)
>> =
>> convert(varchar(50),
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
ttp://old.nabble.com/Help-using-CachedSqlEntityProcessor-tp27337635p27337635.html
Sent from the Solr - User mailing list archive at Nabble.com.