Could you use the facet.query feature
(http://wiki.apache.org/solr/SimpleFacetParameters#facet.query_:_Arbitrary_Query_Faceting)
to reduce it to 2 queries?

So you'd:

1. Send solr the first query
2. Solr executes and returns the query to you
3. You then use the facet results to create a 2nd query with your +20
facet.query queries
3. Solr executes and returns the results of your +20 facet.query queries

Then you'd only have 2 roundtrips.

-Tim


gdeconto wrote:
> 
> Scenario:
> 
> 1. I have a query I want to execute; I would be using the results and
> facets returned
> 2. I also have a couple of dozen other queries that are closely related to
> the first query and to the facets returned by that query.  For each query,
> I would only be using the total number of results documents (aka numFound)
> 3. steps 1 and 2 would occur for each page load/view
> 
> while I could run these queries individually, I am concerned about the
> overhead of having to run +20 solr queries.
> 
> I was wondering if it was a better idea to extend the search or facet
> component somehow so that:
> 
> 1. I send solr the first query
> 2. solr executes the query
> 3. solr then creates (programatically, based on the parameters I pass in
> the first query as well as some of the facet results) and executes +20
> other queries
> 4. solr finally returns me the results and facets of the first query, as
> well as the counts/numFounds obtained from the +20 other queries
> 
> I was thinking that this would save me the time and roundtrip overhead of
> +20 solr queries per page, but I am unsure of how to proceed.
> 
> hopefully this question is not too vague.  any help/example appreciated.
> 

-- 
View this message in context: 
http://old.nabble.com/having-solr-generate-and-execute-other-related-queries-automatically-tp26327032p26328209.html
Sent from the Solr - User mailing list archive at Nabble.com.

Reply via email to