You can think of using facets by category field instead of grouping. It will be faster and categorization can be done against multiple category fields. Try different facet methods.
If you don't need number of documents in each category and number of unique categories is relatively low, you might be interested in following performance improvement https://issues.apache.org/jira/browse/SOLR-5725 Alexey -----Original Message----- From: soodyogesh [mailto:soodyog...@gmail.com] Sent: Thursday, February 20, 2014 16:20 To: solr-user@lucene.apache.org Subject: Grouping performance improvement Im facing slow performance for query where im grouping on a field while querying. Size of index 57 million records, and we would be targeting 100 million + Im using grouping to create category based autosuggest. so when user press "a" I go and search for "a" and group by field say products. Now i have noticed performance of query is really get bad with group by clause. Im at experimental stage so I can change schema or try other alternative. Please let me know if there are way to cleverly design your schema to improve performance or im meeting some option to fine tune. -- View this message in context: http://lucene.472066.n3.nabble.com/Grouping-performance-improvement-tp4118549.html Sent from the Solr - User mailing list archive at Nabble.com.
