Re: Slowness when searching in child documents.

On Jan 3, 2023, at 2:11 AM, Noah Torp-Smith wrote: > > I have also looked at denormalizing > (https://blog.innoventsolutions.com/innovent-solutions-blog/2018/05/avoid-the-parentchild-trap-tips-and-tricks-for-denormalizing-solr-data.html > >

Re: Slowness when searching in child documents.

say "how is it parsed"? Is that output documented somewhere > (other than the solr source code)? > > Best regards, > > /Noah > > > -- > > Noah Torp-Smith (n...@dbc.dk) > > ____ > Fra: Mikhail Khludnev > Sendt: 3. janua

Sv: Slowness when searching in child documents.

olr source code)? Best regards, /Noah -- Noah Torp-Smith (n...@dbc.dk) Fra: Mikhail Khludnev Sendt: 3. januar 2023 19:29 Til: users@solr.apache.org Emne: Re: Slowness when searching in child documents. Hold on. > I remove the first part of the filter

Re: Slowness when searching in child documents.

5 > } > } > > > This fetches 21 workids and it takes more than 20 seconds. If I remove the > first part of the filter (the one with parent which), it fetches 33 workids > in less than 200 miliseconds. I does not matter if I do it with or without > the filtering to material t

Re: Slowness when searching in child documents.

utoRelax": "true", > "ps": 5, > "ps2": 5, > "ps3": 5 > } > } > > > This fetches 21 workids and it takes more than 20 seconds. If I remove the > first part of the filter (the one with parent which), it

Sv: Slowness when searching in child documents.

t;: 5, "ps3": 5 } } This fetches 21 workids and it takes more than 20 seconds. If I remove the first part of the filter (the one with parent which), it fetches 33 workids in less than 200 miliseconds. I does not matter if I do it with or without the filtering to materi

Re: Slowness when searching in child documents.

Hello, Noah. A few notes: Query time depends on the number of results. When one query is slower than another, we can find an excuse in a bigger number of enumerated docs. Examine how the query is parsed in debugQuery output. There are many tricks and pitfalls in query parsers. eg I'm not sure why

Slowness when searching in child documents.

We are facing a performance issuw when searching in child documents. In order to explain the issue, I will provide a very simplified excerpt of our data model. We are making a search engine for libraries. What we want to deliver to the users are "works". An example of a work could be Harry Pott