[TYPO3-v4] List module improvements

[Steffen Kamper]

Hi,

Am 07.03.2011 12:18, schrieb "Christian Müller (Kitsunet)":
> If we provide such "super-list view" it basically doesn't need to care
> about pid. Just show everything and add pid as column.
>

that was my thought too.

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

no - it can be on root page enabling a switch.

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

one query for fe_users but without pid, i don't see a difference.

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

i mean importing like the em offers with "Download all data..."
Then having pid column visible, you can simply change that pid to a 
existing folder.

vg Steffen