Bug #82083
closed
Show all search in BE is extremly slow
Added by András Ottó about 7 years ago.
Updated almost 6 years ago.
Category:
Backend User Interface
Description
If I make a search in the BE I see the autosuggest to pop-up in 1-2 second. If I click on the "Show all" button in the dropdown it takes 2 minutes to see the values.
Version: 8.7.4.
Pages: 880
Records: around 1000 in total.
Example image:
Searchword Impres
Results:
8 pages
2 content elements
5 languages -> (I don't understand why?!)
10 different records.
Reproduced on two servers and a local vagrant.
Another confirmation from Marc Tusch in Slack:
"Confirmed behaviour at a TYPO3 8.7.3 instance with ~2.500 pages... never tried the BE search so far, but true, suggestions come within some seconds, full results need around 1.20min."
Files
Hey, you unfortunately picked the wrong tracker. May I ask, how you got here? We get a lot of reports that belong to the Core project recently. Maybe there's some wrong link?
Steffen Gebert wrote:
Hey, you unfortunately picked the wrong tracker. May I ask, how you got here? We get a lot of reports that belong to the Core project recently. Maybe there's some wrong link?
I came here from the start page of forge.typo3.org and then open an issue.
What should I do with this issue now?
- Project changed from 9 to TYPO3 Core
- Category changed from Development to Backend User Interface
- Priority changed from Should have to Must have
- Target version set to Candidate for patchlevel
- TYPO3 Version set to 8
- PHP Version set to 7.0
Confirmed. 7LTS on server with ~11k pages needs about 3 seconds for show all. Staging instance on very same server times out after 4 minutes using 8.7.4. (Ubuntu 16 with PHP 7)
Concerning your other question: I got only pages, tt_content, sys_domain and sys_template, which are all correct; no sys_languages
- Target version changed from Candidate for patchlevel to next-patchlevel
- Target version deleted (
next-patchlevel)
- Status changed from New to Under Review
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
- Status changed from Resolved to Closed
Also available in: Atom
PDF