[TYPO3-dev] Typo3 Performance

[Martin Kutschker]

Marc Wohlken [quadracom]" <woehlken at quadracom.de>" schrieb:
> Martin Kutschker schrieb:
> 
>>Let's begin and remove those pointless indices suggested on the page.
>>With indices it's like RAM, they are not the solution for everything.
>>Furthermore they must be crafted carefully to be used at all when required.
> 
> 
> 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.

Masi