lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Igor Kustov <>
Subject Solr large boolean filter
Date Sat, 15 Jun 2013 22:49:52 GMT
I know i'm not the first one with this problem. 

I'm currently using solr 4.2.1 with approximately 10 mln documents in the

The index is updated frequently.

The filter_query is just a one big boolean or query by id.

fq=id:(1 2 3 4 ... 50950)

ids list is always different and not sequential.

The problem is that query performance not so well, as you can imagine.

In some particular cases i'm able to do filtering based on different fields,
but in some cases (like 30-40% of all queries) i'm still end up with this
large id filter.

I'm looking for the ways to improve this query performance.

It doesn't seem like solr join could be applied there.

Another option that I found is to somehow use Lucene FieldCacheTermsFilter.
Does it worth a try? 

Maybe i've missed some other options?

View this message in context:
Sent from the Solr - User mailing list archive at

View raw message