[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