Bug #82083

Show all search in BE is extremly slow

Added by András Ottó 13 days ago. Updated 2 days ago.

Status:
New
Priority:
Must have
Assignee:
-
Category:
Backend User Interface
Target version:
-
Start date:
2017-08-11
Due date:
% Done:

0%

TYPO3 Version:
8
PHP Version:
7.0
Tags:
Complexity:
Is Regression:
Sprint Focus:

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."

Bildschirmfoto 2017-08-11 um 10.33.50.png View (64.7 KB) András Ottó, 2017-08-11 10:36

History

#1 Updated by Steffen Gebert 13 days 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?

#2 Updated by András Ottó 13 days 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?

#3 Updated by András Ottó 13 days ago

  • Project changed from forge.typo3.org to 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

#4 Updated by J. Peter M. Schuler 13 days 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

#5 Updated by András Ottó 2 days ago

  • Target version changed from Candidate for patchlevel to next-patchlevel

#6 Updated by András Ottó 2 days ago

  • Target version deleted (next-patchlevel)

Also available in: Atom PDF