lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Brown <...@intelcompute.com>
Subject Grouping performance with MLT
Date Tue, 05 Jul 2016 15:18:17 GMT
Hi All,

I have an index with 10m documents.

When performing an MLT query and grouping by a field, response times are 
roughly 20s.

The group field is currently populated with unique values, as we now 
start to manually group documents (hence using MLT).

The group field has docValues turned on.

The index fits in RAM, and is a single shard with 1 replica, version 6.0.1

Example query is :

http://server:8983/solr/uk/select?group=true&group.field=product&group.limit=10&group.ngroups=true&group.sort=price%20asc&q={!mlt%20qf=name,brand}bg-uk-9cef78e8d5812f14bfebbf2801888a43

<http://solr70.uk.bboxd.net:8983/solr/uk/select?group=true&group.field=product&group.limit=10&group.ngroups=true&group.sort=price%20asc&q=%7B%21mlt%20qf=name,brand%7Dbg-uk-9cef78e8d5812f14bfebbf2801888a43>

With a QTime of 18000.

A "normal" group query is also over 1 second...

http://server:8983/solr/uk/select?group=true&group.field=product&group.limit=10&group.ngroups=true&group.sort=price%20asc&q=iphone

<http://solr70.uk.bboxd.net:8983/solr/uk/select?group=true&group.field=product&group.limit=10&group.ngroups=true&group.sort=price%20asc&q=iphone>

Does anyone have any suggestions for improving performance?

Thanks,
Rob


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message