Re: Understanding Negative Filter Queries

2020-07-14 Thread Chris Dempsey
-- > > Monitoring - Log Management - Alerting - Anomaly Detection > > Solr & Elasticsearch Consulting Support Training - http://sematext.com/ > > > > > > > >> On 14 Jul 2020, at 14:00, Chris Dempsey wrote: > >> > >> I'm trying to understand

Understanding Negative Filter Queries

2020-07-14 Thread Chris Dempsey
I'm trying to understand the difference between something like fq={!cache=false}(tag:* -tag:email) which is very slow compared to fq={!cache=false}(*:* -tag:email) on Solr 7.7.1. I believe in the case of `tag:*` Solr spends some effort to gather all of the documents that have a value for `tag`

Re: Multiple fq vs combined fq performance

2020-07-10 Thread Chris Dempsey
ameter > > Hope it helps, > Alex. > > On Thu., Jul. 9, 2020, 2:05 p.m. Chris Dempsey, wrote: > > > Hi all! In a collection where we have ~54 million documents we've noticed > > running a query with the following: > > > > "fq":["{!cache=false}

Multiple fq vs combined fq performance

2020-07-09 Thread Chris Dempsey
Hi all! In a collection where we have ~54 million documents we've noticed running a query with the following: "fq":["{!cache=false}_class:taggedTickets", "{!cache=false}taggedTickets_ticketId:100241", "{!cache=false}companyId:22476"] when I debugQuery I see:

Re: Prefix + Suffix Wildcards in Searches

2020-06-30 Thread Chris Dempsey
@Mikhail Thanks for the link! I'll read through that. On Tue, Jun 30, 2020 at 6:28 AM Chris Dempsey wrote: > @Erick, > > You've got the idea. Basically the users can attach zero or more tags (*that > they create*) to a document. So as an example say they've created the > tag

Re: Prefix + Suffix Wildcards in Searches

2020-06-30 Thread Chris Dempsey
ies. Here's why it's worth to avoid them > https://www.slideshare.net/lucidworks/search-like-sql-mikhail-khludnev-epam > > On Mon, Jun 29, 2020 at 6:17 PM Chris Dempsey wrote: > > > Hello, all! I'm relatively new to Solr and Lucene (*using Solr 7.7.1*) > but > > I'm lo

Re: Prefix + Suffix Wildcards in Searches

2020-06-29 Thread Chris Dempsey
he data such that you won’t need wildcards. > > Best, > Erick > > > On Jun 29, 2020, at 11:16 AM, Chris Dempsey wrote: > > > > Hello, all! I'm relatively new to Solr and Lucene (*using Solr 7.7.1*) > but > > I'm looking into options for optimizing som

Prefix + Suffix Wildcards in Searches

2020-06-29 Thread Chris Dempsey
Hello, all! I'm relatively new to Solr and Lucene (*using Solr 7.7.1*) but I'm looking into options for optimizing something like this: > fq=(tag:* -tag:*paid*) OR (tag:* -tag:*ms-reply-unpaid*) OR tag:*ms-reply-paid* It's probably not a surprise that we're seeing performance issues with

Re: Default Values and Missing Field Queries

2020-05-25 Thread Chris Dempsey
gt; > And yes, your understanding of adding a new field is correct > > Best, > Erick > On Mon, May 25, 2020, 11:39 Chris Dempsey wrote: > > > I'm new to Solr and made an honest stab to finding this in info the docs. > > > > I'm working on an update to an e

Default Values and Missing Field Queries

2020-05-25 Thread Chris Dempsey
I'm new to Solr and made an honest stab to finding this in info the docs. I'm working on an update to an existing large collection in Solr 7.7 to add a BoolField to mark it as "soft deleted" or not. My understanding is that updating the schema will mean the new field will only exist and have a