[TYPO3-v4] Minutes from the 28th meeting of the release 4.5 team

[Steffen Kamper]

Hi,

Am 24.01.2011 22:39, schrieb Xavier Perseguers:

>>
>> New "Form protection" adds several queries when tokens are generated
>> (and later deleted). E.g. the list view with the extended view open
>> creates several hundreds of queries. For each icon, one additional SQL
>> query is added.
>
> I did not look into this particularly but if might be a very good idea
> to see whether prepared queries could be used because my tests on
> non-MySQL databases have been limited to tiny websites and prepared
> queries are the only _current_ way of having a decent UX even with more
> (similar) queries when using DBAL.
>

our preferred solution doesn't need a single query, so it#s the most 
performant way.

>> See later on for the minutes of our post-meeting with Helmut, where we
>> discussed the issue.
>>
>> Pagetree (initial load)
>> -----------------------------
>>
>> As soon as the pagetree is loaded for the first time (backend.php reload
>> or hitting the "Refresh" button) the whole tree of pages is fetched
>> through individual queries. Up to 500 pages.
>>
>> Steffen later talked to Stefan Galinski and this seems to be a
>> pre-loading of pages (up to 500) to speed up the user interface on
>> future clicks on the tree. Steffen will come up with a solution to have
>> this pre-loading configurable because its effectiveness depends on
>> various factors (it was defaulting to 500 pages).
>
> Same here...
>

patch is pending in list.

vg Steffen