Hello.
Can U help me to understand why datastream search are slower then index search.
I have one Index:
size: 572 GB
shards: 30 primary shards
There are stored some data by one mounth.
I have create datastream witch will be rollover indexes by 30GB size of primary shard.
Each index inside:
shards: 3 primary shards per index
size: 30GB per primary shard
I have reindex documents from old index to datastream. Rollover works perfectly.
But...
I was unpleasantly surprised when run my tests for searching by old index and datastream.
Test cases try to search by 1, 7 and 30 days.
Old index searching is more faster (~2 times) by each of this test cases. I thought datastream searching will be faster or equals of Old index speed.
My query is:
{
"bool": {
"filter": [
{
"bool": {
"minimum_should_match": 1,
"should": [
{
"range": date_range_query
}
]
}
}
],
"must": [
{
"bool": {
"minimum_should_match": 1,
"should": [
{
"bool": {
"minimum_should_match": 1,
"should": [
{
"nested": {
"path": "phrases",
"query": {
"bool": {
"minimum_should_match": 1,
"should": [
{
"match_phrase": {
"phrases.phrase": {
"query": "hello",
"_name": "phrase"
}
}
}
]
}
},
"score_mode": "sum"
}
}
]
}
}
]
}
}
]
}
}
What did I do wrong?
Thx