I have the following problem and can't seem to find a solution: I'm building up a frequently updated solr index. In order to deal with limited ressources I would like to limit the total number of documents in the index. In other words: I would like to declare that no more than (for example) 1.000.000 documents should be in the index. Whenever new documents are added (or better: when newly added documents are being committed), I would like to:
- check, whether the limit is exceeded - delete as many of the oldest documents from the index as necessary, such that the limit is no longer exceeded. Similar to a first in first out list. The problem is: It's easy to check the limit, but how can I delete the oldest documents to go again below the limit? Can I do it with a delete by query request? In that case, I would probably have to limit the number of rows? But I can't seem to find a way to do that. Or would you see a different solution (maybe there is a way to configure the solr core such that it automatically behaves as desribed?)? I would very much appreciate any help! Thanks in Advance. Cheers Michael -- View this message in context: http://lucene.472066.n3.nabble.com/Delete-by-Query-with-limited-number-of-rows-tp3503094p3503094.html Sent from the Solr - User mailing list archive at Nabble.com.
