Hi All, I built the Solr index with 14 M records.
I have > 20 G RAM in my local machine, and the Solr instance was started with -Xms1024m -Xmx8196m The following query: http://localhost:8983/solr/db-mssql/select?q=*:*&fq=GatewayCode:(YYZ)&fq=DestCode:(CUN)&fq=Duration:(5 OR 6 OR 7 OR 8)&fq=DateDep:([20150610 TO 20150810])&facet=true&facet.field=DestCode&facet.field=DateDep&facet.field=GatewayCode&facet.field=HotelName&facet.sort=count&facet.limit=40&facet.mincount=1&rows=30&group=true&group.field=HotelCode&group.ngroups=true&group.facet=true&debugQuery=true The response found a total matched base records of 98105, these records were grouped at hotelcode level to give the ngroups: 143, however, the query only retrieve the first base record of each group, and only 30 groups were retrieved. The performance statistics: Total response time in solr.log: 1791 ms >From the query response page: the query took 764 ms and facet took 1007 ms. Debug took 13 ms This is a typical query that business need. Previously, I was testing the data size of 6 M and no faceted search, the typical response time at single request scenario was around 200 ms. Please let me know if additional information is needed. Thanks -- View this message in context: http://lucene.472066.n3.nabble.com/How-to-do-a-Data-sharding-for-data-in-a-database-table-tp4212765p4213648.html Sent from the Solr - User mailing list archive at Nabble.com.
