ElasticSearch - Search issues

[kdim95]

Laravel framework version: 10.16.1
Aimeos Laravel version: 2023.04.*
PHP Version: 8.2.8
Environment: Linux

Hello,

I am experiencing the following issue:

I have added a custom attribute to individual products (seen).
The "seen" attribute represents how many times a product's detail page has been viewed.
The problem is that if the value of "seen" changes, the "_score" of the search changes.
Even though I'm not taking the product's "seen" value while searching, but just the product code.
Therefore the position of the product in the product listing randomly changes when a product's details page has been viewed.
I am ordering the products by their names in the product listing.
I think that it's the "_score" that's causing this, but not exactly certain, what exactly is causing the "_score" to change when I'm not even including "seen" as a search parameter in elastic?

I've made a custom query to test the search:

Code: Select all

curl -X POST "localhost:9200/my_index/_search?pretty" -H 'Content-Type: application/json' -d '{
    "query": {
        "term": {
            "base.product.code": "<PRODUCT CODE>"
        }
    }
}'

[aimeos]

The score is calculated by Elasticsearch internally and you can influence calculation but I don't know if you can avoid a changed score when a document field is updated.

[kdim95]

Ok, the problem is not the score, but the max_result_window, it sorts only the first 10,000 products and some of them remain out of range and not sorted.
There are more than 100,000 products in the index, which need to be sorted.
I know that increasing the max_result_window would impact performance, so I would like to avoid that.
How can I solve this problem?

[aimeos]

This is a question you should ask in the ElasticSearch discussion forum. Maybe you get an answer there.