We are planning to do an e-commerce shopping site with PHP-MYSQL combination.
I read in almost every link related to Normalization & Denormalization :
Normalize until it hurts, denormalize until it works.
One thing I understood is Normalization is must for good performance , am i right ?
We have to do Denormalization only when we face problems of Performance [ the very low page speed ] , otherwise Denormalization is not required.
Is for 100% it will hurt - Normalization? can we do anything to prevent [not to hurt.] can we take some steps for performance boost other than Denormalizing & Refactoring complete database again.
Can we do Denormalization without doing Normalization before ?