[TYPO3-v4] List module improvements

"Christian Müller (Kitsunet)" christian.mueller at typo3.org
Mon Mar 7 12:18:02 CET 2011


If we provide such "super-list view" it basically doesn't need to care 
about pid. Just show everything and add pid as column.

I don't see a good way to have this in the current UI though. Might need 
a kind of new module).

On 07.03.2011 11:48, Dmitry Dulepov wrote:
> Hi!
>
> Steffen Kamper wrote:
>> Think of fe_users - you may have them spreaded in many folders, no way
>> to see them all at once
>
> This does not help really because the query will still run on the same
> single table. It can be even harder for MySQL if there are many distinct
> pids.
>
>> Think of imported data - you have records with pid that might not exist.
>
> Do you mean import using mysqldump/mysql? Yes, that's possible. However
> this does not really affect the search speed, only amount of records and
> distribution of pid values does. The more different pids, the more
> chances that mysql will prefer full table scan even if a good index
> exists. And together with sorting it becomes "using where; using
> temporary; using filesort", which means we all can go and drink some
> coffee while it sorts. :(
>
> I am not sure how to solve it yet.
>



More information about the TYPO3-project-v4 mailing list