[TYPO3-Performance] mysql performance
Marcus Krause
marcus#exp2008 at t3sec.info
Fri Jul 11 14:13:12 CEST 2008
Christoph Mayer schrieb:
> Hi performance list,
>
> I have a question to mysql performance with this example (this is just a
> example to explain and not real):
>
> [...]
>
> So which table design is better in order to get a performante table?
> - table design 1 has only one entry to each click but a lot of empty fields
> - table design 2 has several entries to each click but no empty fields
Hi!
Of what performance you are talking? Read or write or both? Which
storage engine?
EXPLAIN SELECT ...
helps you to compare read performance.
Based on experience and general knowledge: denormalization improves
performance.
Marcus.
More information about the TYPO3-Performance
mailing list