Getting huge difference in QTime for terms.lower and terms.prefix

2014-04-10 Thread Jilani Shaik
Hi,

When I queried terms component with a terms.prefix the QTime for it is
100 milli seconds, where as the same query I am giving with terms.lower
then the QTime is  500 milliseconds. I am using the Solr Cloud.

I am giving both the cases terms.limit as 60 and terms.sort=index.

Query1 Params:
terms.fl=field_Nameterms.limit=60terms.prefix=bwt=jsonterms.sort=indexshard.keys=shard_key
QTime: 100 milli seconds


Query2 Params:
terms.fl=field_Nameterms.limit=60terms.lower=bwt=jsonterms.sort=indexshard.keys=shard_key
QTime: 500 milliseconds


The response is giving the same terms in both queries, But the QTime is
different.


Please let me know why is the difference in QTime for both approaches.


Thanks,
Jilani


Re: Getting huge difference in QTime for terms.lower and terms.prefix

2014-04-10 Thread Jilani Shaik
Please provide suggestions what could be the reason for this.

Thanks,


On Thu, Apr 10, 2014 at 2:54 PM, Jilani Shaik jilani24...@gmail.com wrote:

 Hi,

 When I queried terms component with a terms.prefix the QTime for it is
 100 milli seconds, where as the same query I am giving with terms.lower
 then the QTime is  500 milliseconds. I am using the Solr Cloud.

 I am giving both the cases terms.limit as 60 and terms.sort=index.

 Query1 Params:

 terms.fl=field_Nameterms.limit=60terms.prefix=bwt=jsonterms.sort=indexshard.keys=shard_key
 QTime: 100 milli seconds


 Query2 Params:

 terms.fl=field_Nameterms.limit=60terms.lower=bwt=jsonterms.sort=indexshard.keys=shard_key
 QTime: 500 milliseconds


 The response is giving the same terms in both queries, But the QTime is
 different.


 Please let me know why is the difference in QTime for both approaches.


 Thanks,
 Jilani