On 4/7/2021 12:49 AM, Shawn Heisey wrote:
On 4/7/2021 12:29 AM, jay harkhani wrote:
Query :
https://drive.google.com/file/d/1RHnIVsK7m-T8_3it97jLquyfBFm3OGfj/view
Schema File:
https://drive.google.com/file/d/1SoKpucgtws3teW0QbV7UKg9xiV1cYuXJ/view
For better performance we used term query but still not getting quick
result. To analyze further more we found that if we remove grouping
field or we reduce no. of ids from query, it executes fast. Is there
any better option for fast execution when large query or more ids pass
in one field?
Can you provide a screenshot like the ones mentioned here?
I forgot to mention: Grouping is also slow. It can be sped up by using
fields that have docValues. I notice that your schema for the fields
used in grouping does NOT explicitly request docValues.
I do not remember if Solr 6.1.0 contains the change where we made most
field types include docValues by default. I will go diving into the
source code to see if I can figure that out. If you check the Schema
section in the admin UI, you can see if fields like doc_id have
docValues or not. If they don't, you'll want to add it to the schema.
Changes like that do require a full reindex.
https://cwiki.apache.org/confluence/display/SOLR/HowToReindex
For performance problems, I always suspect "not enough RAM" as a strong
candidate for the problem. The screenshot linked in the previous
message will help determine if that's what you are running into.
Thanks,
Shawn
