Deleting by _id vs deleting by term performance issue

Elastic Stack Elasticsearch
1

Hi,

I have an performance issue regarding deleting from elasticsearch. I
have 2 cases for deletion : 1. delete by term and 2. delete by _id. The
delete field is unique.

1. DELETE by term. The field I want to delete by term is mapped below :

.startObject(ListenerColumns.SUID.getColumnName())
.field("type", "string")
.field("index", "not_analyzed")
.field("store", false)
.endObject()

Deleting query : 
        DeleteByQueryRequestBuilder prepareDelete =

client.prepareDeleteByQuery(index);
prepareDelete.setTypes(table);
prepareDelete.setQuery(
termQuery(ListenerColumns.SUID.getColumnName(),
suidValue)
);

The upper deleting is taking some time comparing with the next situation
:

    1. DELETE by _id*. The Suid is saved in *_id *field.

        DeleteRequestBuilder prepareDelete = client.prepareDelete();
  DeleteRequestBuilder deleteRequest =
  prepareDelete.setIndex(index).setType(table).setId(suidValue);

My question is how should I configure the elasticsearch mapping for
getting the same performance, in delete by term - first case, like in
delete by _id case - second case?

Thank you,
Ciprian

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/6d5e69aa-de37-4d1a-8b7d-d5af2e143d7f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.