[TYPO3-dev] Typo3 Performance

["Marc Wo"hlken [quadracom]"]

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

Regards
 Marc


-- 
...........................................................
Marc Wo"hlken

Quadracom - Proffe & Wo"hlken

Fedelho"ren 45a                 WWW: http://www.quadracom.de
D-28203 Bremen                E-Mail: woehlken at quadracom.de
______________             PGP-Key: http://pgp.quadracom.de