You are viewing a plain text version of this content. The canonical link for it is here.

Posted to solr-user@lucene.apache.org by Robert Brown <ro...@intelcompute.com> on 2016/07/05 15:18:17 UTC

Grouping performance with MLT

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