Project

General

Profile

Actions

Bug #21074

closed

TCEforms suggest doesn't find everything on large sites and is slow

Added by Steffen Gebert over 14 years ago. Updated over 13 years ago.

Status:
Closed
Priority:
Should have
Category:
-
Target version:
-
Start date:
2009-09-16
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.3
PHP Version:
5.2
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

On large sites (e.g. 20.000 pages) there are situations, when suggest doesn't find all results.
This can happen, if you e.g. have 500 users and each one has site called "links" and nobody has access to the other's site. So suggest would find this page for some users and for some not.

There are several problems causing this:
  • During each query 50 elements are fetched
  • Recursion depth of fetching another 50 recurds is limited to $this->maxItems (which is 10 and should have nothing to do with recursion depth at all..)

Fetching 50 records again and again also takes a long time and because of PHP's maximum nesting level of 100, keeping 50 and removing the recursion limiter is no good idea.

To speed the process up and fetch all available records, increase the number of fetched records exponentially.

(issue imported from #M11979)


Files

11979.diff (1.33 KB) 11979.diff Administrator Admin, 2009-09-16 21:03
11979_v2.diff (1.11 KB) 11979_v2.diff Administrator Admin, 2009-10-01 12:21

Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #21342: Improve TCEforms SuggestClosed2009-10-22

Actions
Actions #1

Updated by Steffen Gebert over 14 years ago

.. and remove the recursion limiter. Nobody should have 2^100 records in a table :-P

Actions #2

Updated by Rupert Germann over 14 years ago

committed to trunk rev 6083

Actions

Also available in: Atom PDF