We are using Elasticsearch (ES) for GUI search in our products.
Years ago we integrated Elasticsearch-1.7.
Now we utilize ES 6.4.
Now we have to re-index our data.
The source data (DB) is a located on a relational database (Oracle).
So far so good.
I do performance measurements within a docker (compose) environment.
First scenario is that ES, DB and the indexer are co-located on the same host machine.
ES-6.4 is as four times as fast as ES-1.7 for the same data amount to index.
Second scenario is that the Database is located on another host machine than ES.
The amount of time to index the data flips from 1:4 (ES64 : ES17) to 2:1,
meaning ES-6.4 is as half as fast as ES-1.7 for the same amount of data.
Does anyone have similar experience?
Any ideas what's happening there?
I find it quite confusing that ES-1.7 is double as fast es ES-6.4 when the database is not on the same host as the Elasticsarch instance.