Hi

I have a set of document IDs from one core and i want to query another core
using the ids retrieved from the first core...the constraint is that the
size of doc ID set can be very large. I want to:

1) retrieve these docs from the 2nd index
2) facet on the results

I can think of 3 solutions:

1) boolean query
2) terms fq
3) use a DB rather than Solr

I am trying to keep latencies down so prefer to not use (3). The problem
with (1) is maxBooleanclauses is hardwired and I am not sure when I will
hit the exception. Option (2) seems to also hit limits.. so if I do

select?fl=*&q=*:*&facet=true&facet.field=title&fq={!terms
f=id}<LONG_LIST_OF_IDS>

solr just goes blank. I have tried adding cost=200 to try to run the query
first fq={!terms f=id cost=200} but still no good. Paging on doc IDs could
be a solution but the problem then is that the faceting results correspond
to the paged IDs and not the global set.

My filter cache spec is as follows

  <filterCache class="solr.FastLRUCache"
                 size="1000000"
                 initialSize="1000000"
                 autowarmCount="100000"/>


What would be the best way for me to solve this problem?

thank you

Reply via email to