Re: deletebyQuery vs deletebyId

2018-05-24 Thread Jay Potharaju
/updates) especially in SolrCloud mode. Here are some thoughts > on > >>> DBQ: http://www.od-bits.com/2018/03/dbq-or-delete-by-query.html < > >>> http://www.od-bits.com/2018/03/dbq-or-delete-by-query.html> > >>> > >>> Thanks, > >

Re: deletebyQuery vs deletebyId

2018-05-23 Thread Erick Erickson
ww.od-bits.com/2018/03/dbq-or-delete-by-query.html> >>> >>> Thanks, >>> Emir >>> -- >>> Monitoring - Log Management - Alerting - Anomaly Detection >>> Solr & Elasticsearch Consulting Support Training - http://sematext.com/ >>> >>> >>> >>> > On 23 May 2018, at 02:35, Jay Potharaju <jspothar...@gmail.com> wrote: >>> > >>> > Hi, >>> > I have a quick question about deletebyQuery vs deleteById. When using >>> > deleteByQuery, if query is id:123 is that same as deleteById in terms of >>> > performance. >>> > >>> > >>> > Thanks >>> > Jay >>> >>>

Re: deletebyQuery vs deletebyId

2018-05-23 Thread Erick Erickson
>> Emir >> -- >> Monitoring - Log Management - Alerting - Anomaly Detection >> Solr & Elasticsearch Consulting Support Training - http://sematext.com/ >> >> >> >> > On 23 May 2018, at 02:35, Jay Potharaju <jspothar...@gmail.com> wrote: >

Re: deletebyQuery vs deletebyId

2018-05-23 Thread Jay Potharaju
> Thanks, > Emir > -- > Monitoring - Log Management - Alerting - Anomaly Detection > Solr & Elasticsearch Consulting Support Training - http://sematext.com/ > > > > > On 23 May 2018, at 02:35, Jay Potharaju <jspothar...@gmail.com> wrote: > > > > Hi,

Re: deletebyQuery vs deletebyId

2018-05-23 Thread Emir Arnautović
gt; On 23 May 2018, at 02:35, Jay Potharaju <jspothar...@gmail.com> wrote: > > Hi, > I have a quick question about deletebyQuery vs deleteById. When using > deleteByQuery, if query is id:123 is that same as deleteById in terms of > performance. > > > Thanks > Jay

Re: deletebyQuery vs deletebyId

2018-05-22 Thread Shawn Heisey
On 5/22/2018 6:35 PM, Jay Potharaju wrote: I have a quick question about deletebyQuery vs deleteById. When using deleteByQuery, if query is id:123 is that same as deleteById in terms of performance. If there is absolutely nothing else happening to update the index, the difference between

deletebyQuery vs deletebyId

2018-05-22 Thread Jay Potharaju
Hi, I have a quick question about deletebyQuery vs deleteById. When using deleteByQuery, if query is id:123 is that same as deleteById in terms of performance. Thanks Jay

Re: Solr DeleteByQuery vs DeleteById

2016-08-09 Thread Bharath Kumar
Hi Danny and Daniel, Thank you so much for your inputs. Actually we use deleteByIds, but because we need the CDCR solution to work for us, we are having issues when we use deleteById. The deleteById logs a transaction in the transaction logs and that when passed over to the target site, the CDCR

Re: Solr DeleteByQuery vs DeleteById

2016-08-09 Thread Daniel Collins
Seconding that point, we currently do DBQ to "tidy" some of our collections and time-bound them (so running "delete anything older than X"). They have similar issues with reordering and blocking from time to time. On 9 August 2016 at 14:20, danny teichthal wrote: > Hi

Re: Solr DeleteByQuery vs DeleteById

2016-08-09 Thread danny teichthal
Hi Bharath, I'm no expert, but we had some major problems because of deleteByQuery ( in short DBQ). We ended up replacing all of our DBQ to delete by ids. My suggestion is that if you don't realy need it - don't use it. Especially in your case, since you already know the population of ids, it is

Solr DeleteByQuery vs DeleteById

2016-08-08 Thread Bharath Kumar
Hi All, We are using SOLR 6.1 and i wanted to know which is better to use - deleteById or deleteByQuery? We have a program which deletes 10 documents every 5 minutes from the SOLR and we do it in a batch of 200 to delete those documents. For that we now use deleteById(List ids, 1) to