lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ketan Thanki <ktha...@asite.com>
Subject query Slower with Document Routing while Use on Heavy Index Size
Date Wed, 11 Oct 2017 14:50:14 GMT
HI,

I have issue as mentions below while use Document Routing.

1: Query  is slower with heavy index for below detail.
Config: 4 shard and 4 replica,with  8.5 GB Index Size(2GB Index Size for each shard).
-With routing parameter:
q=worksetid_l:2028446%20AND%20modelid_l:23718&rows=10000&_route_=1041040!2964!&wt=json
taking QTime=3.4
-Without routing parameter:
q=worksetid_l:2028446%20AND%20modelid_l:23718&rows=10000&wt=json taking QTime=3.2

2:Query is faster with lowest index for below detail.
Config: 2 shard and 2 replica  with 190 mb for 1 shard (Data index only in 1 shard with document
routing)
-With routing parameter:
q=worksetid_l:103963 AND modelid_l:3611&rows=10000&wt=json&_route_=79190!451!&wt=json
taking QTime=39
-Without routing parameter:
q=worksetid_l:103963 AND modelid_l:3611&rows=10000&wt=json taking QTime=1.4

so issue is while query on heavy index size its getting slower with routing parameter which
is same like without routing parameter.

Please do needful.


-Ketan.

Please cast a vote for Asite in the 2017 Construction Computing Awards: Click here to Vote<http://caddealer.com/concompawards/index.php?page=cca2017vote>

[CC Award Winners!]


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