Re: Delete by Query with limited number of rows

2011-11-14 Thread mikr00
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

Re: Delete by Query with limited number of rows

2011-11-13 Thread mikr00
Hi Yury, thank you very much for your quick reply. Currently I have a timestamp field (solr.DateField) and every time I add a document I use NOW for the timestamp field. I only commit documents on the core every four hours. This works fine with the timestamp since I can use NOW. However, I

Delete by Query with limited number of rows

2011-11-12 Thread mikr00
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)