Re: Slow quires and facets

2020-02-15 Thread Mikhail Khludnev
I don't have any particular idea. Probably it's worth to start from learning debugQuery=true output. There are caveats: - it takes a while - it's worth to limit shards to a few ones - it used to produce incorrect json, and worked in only in wt=xml At least it let to sneak something about the

RE: Slow quires and facets

2020-02-15 Thread Rudenko, Artur
Promoting my question Artur Rudenko -Original Message- From: Rudenko, Artur Sent: Wednesday, February 12, 2020 10:33 PM To: solr-user@lucene.apache.org Subject: Slow quires and facets Hello everyone, I'm am currently investigating a performance issue in our environment: 20M large

Slow quires and facets

2020-02-12 Thread Rudenko, Artur
Hello everyone, I'm am currently investigating a performance issue in our environment: 20M large PARENT documents and 800M nested small CHILD documents. The system inserts about 400K PARENT documents and 16M CHILD documents per day. (Currently we stopped the calls insertion to investigate the