# Temporarily disable ID lookup

**URL:** <https://discuss.elastic.co/t/temporarily-disable-id-lookup/78238>\
**Category:** Elasticsearch\
**Created:** [March 11, 2017, 12:23pm UTC](https://discuss.elastic.co/t/temporarily-disable-id-lookup/78238 "2017-03-11T12:23:20Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Zaid\_Amir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/zaid_amir/32/54679_2.png) [@Zaid\_Amir](https://discuss.elastic.co/u/Zaid_Amir)\
**Post date:** [March 11, 2017, 12:23pm UTC](https://discuss.elastic.co/t/temporarily-disable-id-lookup/78238/1 "2017-03-11T12:23:20Z")

</div>

Hi,

I am trying to index an initial workload of ~1 billion documents into ES 5.2. The documents are pulled from an MYSQL database and they already contain a unique ID and I want to use the same IDs in ES for a quick reference.

I was reading about how to [tune indexing](https://www.elastic.co/guide/en/elasticsearch/reference/current/tune-for-indexing-speed.html) and I have tried disabling index refresh and replicas and it sped up the process so now I am wondering if there is a way to disable ID lookup as it might speed up things more.

So is there a way to do this?

Regards

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [March 11, 2017, 2:26pm UTC](https://discuss.elastic.co/t/temporarily-disable-id-lookup/78238/2 "2017-03-11T14:26:41Z")

</div>

I don't think so.

But is it really slow? What are you using to do the extraction?

---

<div class="post-metadata">

**Author:** ![Zaid\_Amir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/zaid_amir/32/54679_2.png) [@Zaid\_Amir](https://discuss.elastic.co/u/Zaid_Amir)\
**Post date:** [March 11, 2017, 2:44pm UTC](https://discuss.elastic.co/t/temporarily-disable-id-lookup/78238/3 "2017-03-11T14:44:50Z")

</div>

Its not slow per say, however as I move forward with the actual process I will have the shutdown the system to prevent new data from being inserted in the db untill the process finish so I would like to minimize the downtime as much as possible.

---

<div class="post-metadata">

**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\
**Post date:** [March 11, 2017, 3:38pm UTC](https://discuss.elastic.co/t/temporarily-disable-id-lookup/78238/4 "2017-03-11T15:38:17Z")

</div>

There is no need for downtime or prevent new data from being inserted if you use timestamps.

---

<div class="post-metadata">

**Author:** ![Zaid\_Amir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/zaid_amir/32/54679_2.png) [@Zaid\_Amir](https://discuss.elastic.co/u/Zaid_Amir)\
**Post date:** [March 11, 2017, 4:51pm UTC](https://discuss.elastic.co/t/temporarily-disable-id-lookup/78238/5 "2017-03-11T16:51:15Z")

</div>

We would like to do the whole tranistion in a single shot without having to worry about new records.

---

<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:** [April 8, 2017, 4:51pm UTC](https://discuss.elastic.co/t/temporarily-disable-id-lookup/78238/6 "2017-04-08T16:51:59Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.