[TYPO3-core] RFC #11979: TCEforms suggest doesn't find everything on large sites and is slow

[Steffen Gebert]

On Sat, 19 Sep 2009 02:25:14 +0200, Steffen Gebert  
<steffen at steffen-gebert.de> wrote:

> On Wed, 16 Sep 2009 21:09:16 +0200, Steffen Gebert
> <steffen at steffen-gebert.de> wrote:
>
>> Bugtracker references:
>> http://bugs.typo3.org/view.php?id=11979
>
> Redefined bug description:
> As soon as > 50 pages/records with the same name exist and the user has  
> no
> access to them, the other ones with access will never be found.
>
> Recursion is totally useless, when we always query SQL with "LIMIT 0,50"  
> -
> every time the same 50 records are retrieved.
>
> Attached patch fixes this.
>
> Now search works, but still a bit inefficient (waiting for Andreas'
> improvements first).


REMINDER for v2

Could we fix this in beta1?

It's a quite obvious bug: $this->start always stays at 0, so we get "LIMIT  
0,50" again and again from DB.

Thanks
Steffen