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)
Optimise works
Optimise times out
PHP 8.2 Joomla 5.2.1
max_execution_time set to 720 (maximum)
I'm working on a CLI solution with new queries (tests show that the query in question runs 32 minutes...)
Labels |
Removed:
?
|
Labels |
Added:
No Code Attached Yet
|
Status | New | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2024-11-24 09:50:49 |
Closed_By | ⇒ | Hackwar |
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.
Status | Closed | ⇒ | New |
Closed_Date | 2024-11-24 09:50:49 | ⇒ | |
Closed_By | Hackwar | ⇒ |
I have 45k article. Indexing literally takes 6-7 hours
Please have a look at #44485, which should solve the issue actually.