Smart Search Optimise times out

[MacJoom]

Steps to reproduce the issue

On a website with a lot of articles (in my case >88000)

Go to Smart Seach, Index
Either do:

• Index, the index process takes a few hours but works, in the end there is no success message because the optimise process is run at the end times out (in the background)

• Optimise, the process times out (e.g. 504 Gateway Time-out)

Expected result

Optimise works

Actual result

Optimise times out

System information (as much as possible)

PHP 8.2 Joomla 5.2.1
max_execution_time set to 720 (maximum)

Additional comments

I'm working on a CLI solution with new queries (tests show that the query in question runs 32 minutes...)

[Hackwar]

Please have a look at #44485, which should solve the issue actually.

[Hackwar]

Since #44485 is already RTC and should indeed greatly improve this issue, I'm closing this ticket for now. If #44485 doesn't solve your issue, please open it again.

[MacJoom]

I have tested unsuccessfully with the prebuilt package on my local test website. I found the culprit query in the onFinderGarbageCollection() routine in administrator/components/com_finder/src/Indexer/Adapter.php . The query before the loop takes very long with a lot of items in the finder_links table.