Hi, Is there an efficient way to hit solr for complex time consuming queries? I have a requirement where I need to pivot on 4 fields. Two fields contain facet values close to 50. And the other 2 fields have 5000 and 8000 values. Pivoting on the 4 fields would crash the server.
Is there a better way to get the data? Example Query Params looks like this: &facet.pivot=country,state,part_num,part_code Thanks, Lewin