: the list of IDs is constant for a longer time. I will take a look at : these join thematic. : Maybe another solution would be to really create a whole new : collection or set of documents containing the aggregated documents (from the : ids) from scratch and to execute queries on this collection. Then this : would take : some time, but maybe it's worth it because the querying will thank you.
Another avenue to consider... http://lucene.apache.org/solr/api-4_0_0-ALPHA/org/apache/solr/schema/ExternalFileField.html ...would allow you to map values in your "source_id" to some numeric values (many to many) and these numeric values would then be accessible in functions -- so you could use something like fq={!frange ...} to select all docs with value 67 where your extenral file field says that value 67 is mapped ot the following thousand source_id values. the external field fields can then be modified at any time just by doing a commit on your index. -Hoss
