[TYPO3-Performance] General questions

[Martin Kutschker]

Mathias Schreiber [TYPO3] schrieb:
> 
> You will see that a lot of queries run multiple times.
> E.g. Let's say you hit one page 20 times - this should result in a
> queryCount of 20 for query A (at least this would be the ideal situation).
> But query A is executed over a thousand times.

One query is the access rights query in tslib_content for a page. This
is done for each CONTENT object. If you have multiple columns, you'll
get the same query repeated. But it's excatly the same so, Mysql query
cache will help.

Another odd thing is that at least for BE authentication the
authentication tables are queried twice. Some strange logic checks and
then rechecks them.

Masi