Hi Erick, hi Yury, thanks to your input I found a perfect solution for my case. Even though this is not a solr-only solution, I will just briefly describe how it works since it might be of interest to others:
I have put up a mysql database holding two tables. The first only has a primarykey with auto-increment and nothing else. The second has a primarykey but without auto-increment and also fields for the content I store in solr. Now, before I add something to the solr core, I add an entry to the first mysql database. After the insertion, I get the primarykey for the action. I check, whether it is above my limit of documents. If so, I empty the first mysql table and reset the auto-increment to zero. I than insert a mysql entry to the second table using the primarykey taken from the first table (if the primarykey exists, I do not add an entry but update the existing one). And finally I have a solr core which holds my searchable data and has a uniquekey field. Into this core I add a new document by using the primarykey from the first mysql table for the uniquekey field. The solution has two main benefits for me: - I can precisely control the number of documents in my solr core. - I do now also have a backup of my data in mysql Thank you very much for your help! -- View this message in context: http://lucene.472066.n3.nabble.com/Delete-by-Query-with-limited-number-of-rows-tp3503094p3506380.html Sent from the Solr - User mailing list archive at Nabble.com.
