# Elasticsearch CustomQueryBuilder slowly

**URL:** <https://discuss.elastic.co/t/elasticsearch-customquerybuilder-slowly/14694>\
**Category:** Elasticsearch\
**Created:** [December 4, 2013, 5:55am UTC](https://discuss.elastic.co/t/elasticsearch-customquerybuilder-slowly/14694 "2013-12-04T05:55:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![awnuxkjy](https://avatars.discourse-cdn.com/v4/letter/a/46a35a/32.png) [@awnuxkjy](https://discuss.elastic.co/u/awnuxkjy)\
**Post date:** [December 4, 2013, 5:55am UTC](https://discuss.elastic.co/t/elasticsearch-customquerybuilder-slowly/14694/1 "2013-12-04T05:55:40Z")

</div>

I used CustomQueryBuilder cost 634ms. for example：

[2013-12-04 11:49:12,300][TRACE][index.search.slowlog.query] [h35] [cms][1] took[634ms], took\_millis[634], types[news], stats[], search\_type[QUERY\_THEN\_FETCH], total\_shards[10], source[{"from":0,"size":10,"query":{"custom\_score":{"query":{"filtered":{"query":{"query\_string":{"query":"大连机场","fields":["title","content"],"analyzer":"ik"}},"filter":{"bool":{"must":{"range":{"updatetime":{"from":1354591800,"to":1386127800,"include\_lower":true,"include\_upper":true}}}}}}},"script":"int day=doc['updatetime'].value/86400;if (day \< currentDay) {int delta=(currentDay-day)/5+1;if(delta\<32){\_score=\_score+6_pow(0.9,delta);}else{\_score=\_score+3_pow(0.9,31);}} else if (day \> currentDay) {\_score=\_score+3\*pow(0.9,31);} else{\_score=\_score+3;}","params":{"currentDay":16043}}},"fields":["id","channelid","catid","model","title","content","thumb","url","updatetime"],"sort":[{"\_score":{"order":"desc"}},{"updatetime":{"order":"desc"}}],"highlight":{"pre\_tags":["_"],"post\_tags":["_"],"encoder":"UTF-8","fields":{"title":{},"content":{"fragment\_size":72,"number\_of\_fragments":3}}}}], extra\_source[],

I dont used CustomQueryBuilder，query very fast。

What is the reason？ thanks！

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 2:03am UTC](https://discuss.elastic.co/t/elasticsearch-customquerybuilder-slowly/14694/2 "2017-07-06T02:03:28Z")

</div>