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
