[TYPO3-Performance] General questions

[Martin Kutschker]

Mathias Schreiber [TYPO3] schrieb:
> t3lib_page->getRootline ist something that could be improved massively.

4.2 has a rootline cache and I have an even more improved version of the
caching mechanism (local for a script run).

Ingo has suggested a global rootline tree cache for 4.3.

Masi

> I still think that caching the query in mysql is basically a good thing,
> but removing duplicate queries (real dupes) will be faster, any way you
> put it.

Issuing the same query in the same http request is somewhat dumb. The
Maysql query cache should be used for the same query originating from
different http requests.

>> Another odd thing is that at least for BE authentication the
>> authentication tables are queried twice. Some strange logic checks and
>> then rechecks them.
> 
> I could try to did up our VM that hosted the MSSQL DBAL implementation.
> The query analyzer in MSSQL ist the best I've seen so far (I'm sure the
> oracle thingy catched up, but never saw the new one though).

As Dmitry said it is built-in into the authentication code. I tried to
understand, but I failed miserably. I don't get the idea of how the code
is supposed to work.

Masi