Re: Design Conundrum - Data Types
Posted by:
Rick James
Date: August 17, 2011 10:36PM
> My worry is that all the conversion magic will drag the speed of any searches down and the whole thing just isn't very elegant.
* The conversions won't kill you, the JOINs, etc will.
* Not elegant.
We rant on the Performance forum repeated against EAV / Key-value schema designs. This may be my best explanation of what to do instead:
http://forums.mysql.com/read.php?125,428546,428769
Subject
Written By
Posted
Re: Design Conundrum - Data Types
August 17, 2011 10:36PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.