Bug #82083
closed
Show all search in BE is extremly slow
100%
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
Updated by Steffen Gebert over 6 years ago
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?
Updated by András Ottó over 6 years ago
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?
Updated by András Ottó over 6 years ago
- 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
Updated by J. Peter M. Schuler over 6 years ago
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
Updated by András Ottó over 6 years ago
- Target version changed from Candidate for patchlevel to next-patchlevel
Updated by András Ottó over 6 years ago
- Target version deleted (
next-patchlevel)
Updated by Gerrit Code Review over 6 years ago
- Status changed from New to Under Review
Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53930
Updated by Susanne Moog over 6 years ago
Just pushed a patch for that - comparison of before and after: https://blackfire.io/profiles/compare/69c47f10-77fa-4145-8856-a62e75902e2b/graph
Updated by Gerrit Code Review over 6 years ago
Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53930
Updated by Gerrit Code Review over 6 years ago
Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53930
Updated by Gerrit Code Review over 6 years ago
Patch set 1 for branch TYPO3_8-7 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/54206
Updated by Anonymous over 6 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset d139035818d2c5a5dd613ea076856624ef4df20c.
Updated by 