[TYPO3-v4] List module improvements

[Dmitry Dulepov]

Hi!

Jigal van Hemert wrote:
> If there are more than N tables, just display the headings and load the
> records if the user wants to open a table (AJAX call). This costs
> another click, but the end result is faster.

Open tables should be loaded static. It is very annoying to wait for a 
normal table and next to see spinning icons on the loaded table. Users 
already say that spinning icons in BE is something they do not appreciate.

For loading with ajax, tables should be optimized first. List module is 
quite stupid actually, it tries to load records from absolutely all tables 
in the system for the current page. So 200 tables => 200 queries to 200 
tables without proper indexes. You can imagine the result. As to the ajax, 
it will simply timeout in many cases because with large tables fetching by 
pid would takes more than 30 seconds.

So optimization of table indexes first.

-- 
Dmitry Dulepov
TYPO3 core&security team member
E-mail: dmitry.dulepov at typo3.org
Web: http://dmitry-dulepov.com/