[TYPO3-performance] Backend Performance TYPO3 4.3 - Strange Behavior

[Dmitry Dulepov]

Hi!

Thomas "Thasmo" Deinhamer wrote:
> if indexes/keys won't slow down 'small' sites, it's a good idea to
> introduce indexes/keys

There are several issues here... Many indexes will actually slow down the
site because:
- they all have to be checked and updated when the table is changed
- they all will be considered for the query when query is executed

Making good keys is not easy because it requires observation of a real
data. With some dummy data it is not possible to find good indexes. I used
to make different indexes on different sites depending on site specifics...

-- 
Dmitry Dulepov
TYPO3 expert / TYPO3 core&security teams member
Twitter: http://twitter.com/dmitryd
Read more @ http://dmitry-dulepov.com/