confused with SQL cached entity processor

[bbarani <bb...@gmail.com>]

Hi,

I am using cached SQL entity processor in my data config, please find below
the structure of my data config file.

<entity name="object" query="select * from x where objecttype=''test1'">
      <entity name="objectproperty"  query="select * from y"
processor="CachedSqlEntityProcessor"   cacheKey="ObjectUID"
cacheLookup="object.uid">
      </entity>
    <entity name="relationship"  query="select * from z"
processor="CachedSqlEntityProcessor"     cacheKey="ObjectUID"
cacheLookup="object.uid">
    </entity>
</entity>

Now if  the data is returned by all the 3 entities I can see that SOLR
issues just 3 queries to the data source. In case if one of the entity
returns no results (like if any particular objecttype doesnt have any
relationship associated with it), SOLR issues many queries to data source. 

Any reasons / pointers to help??

Thanks,
Barani

-- 
View this message in context: http://lucene.472066.n3.nabble.com/confused-with-SQL-cached-entity-processor-tp876765p876765.html
Sent from the Solr - User mailing list archive at Nabble.com.