[TYPO3-dev] Typo3 Performance

[Martin Kutschker]

Marc Wohlken [quadracom]" <woehlken at quadracom.de>" schrieb:
> Martin Kutschker schrieb:
> 
>>Marc Wohlken [quadracom]" <woehlken at quadracom.de>" schrieb:
>>
>>>Those indices are well chosen and have a huge impact on TYPO3
>>>performance if *both* of the following conditions are met:
>>>1) There are deleted and /or hiden pages (the more there are the bigger
>>>the performance gain)
>>
>>I doubt that. Using mutliple inidices with pid/flag contents will never
>>be used in a typical TYPO3 query. As you have normally other conditions
>>(and sorting) Mysql will have to read the row anyway.
> 
> 
> Fields "deleted" and "hidden" were only chosen as an example. Several
> other interesting fields are available, some of them are already
> mentioned at http://wiki.typo3.org/index.php/Performance_tuning

That's what I meant in my last post. Don't pick some tables and columsn at 
random "for example".

Show me real live indices for specific everyday queries of TYPO3.

Masi