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

[Thomas "Thasmo" Deinhamer]

Am 02.06.2010 15:54, schrieb Dmitry Dulepov:
> 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...

Ah, okay - I see. But maybe there are general queries which would 
'always' benefit from using keys/indexes - not sure if there are any so.

Thomas