[TYPO3-dev] Typo3 Performance

["Marc Wo"hlken [quadracom]"]

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)
2) The MySQL-Querycache can't hold the full tables / corresponding
queries mentioned at that wiki page

Obviously those indices won't help anything if everything is stored in
memory or if all indexed columns have a cardinality of 1.

Those are the facts.

Possibly combined indices would work even better under the conditions
mentioned above.

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