Issue Summary

Since Asset 10.x, Asset Free Text Indexing is taking more time than before.

This is reproducible on Data Center: Yes

Steps to Reproduce

We have scheduled a process to perform Assets Free Text indexing every day at 00:00. Also, Assets Free Text indexing will be triggered after every Asset Reindex process. Due to changes with Asset 10.x, Assets Free Text indexing is taking more time.

For example, Free Text Indexing which took around 30 mins with the previous versions now taking 50 minutes to complete.

Expected Results

Free Text Indexing to be more efficient and less time consuming

Actual Results

Free Text Indexing is taking more time with the recent versions than the previous versions.

Workaround

Currently, there is no known workaround for this behaviour. A workaround will be added here when available