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

[Rupert Germann]

hi steffen,

thanks for the reminder I'll have a look at the patch now.

greets
rupert


Steffen Gebert schrieb:
> 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