[TYPO3-dev] Typo3 Database design question (optimization / indices)

[Marc Wöhlken]

Dimitri Tarassenko schrieb:
> The only possible negative impact of a new [non-unique,
> non-constraining] index is decrease in INSERT/UPDATE queries
> performance - any index is a trade off of slower writes for faster
> reads.

That's a good point. All querys changing data will probably be a little
bit slower.

> In case of TYPO3 I think this is not an issue at all.

I agree, as adding and/or modifying data definetly dos not make up the
biggest amount of mysql workload.

CU
 Marc