In article <[EMAIL PROTECTED]>, Hassan Schroeder <[EMAIL PROTECTED]> writes:
> Paul DuBois wrote: >> Before MySQL 5, DECIMAL values are stored as strings, so operations >> are less efficient than for integers. >> In MySQL 5, the representation of DECIMAL has changed to binary >> format, >> so it's more efficient than before. It's probably safe to say that >> integer is still a bit more efficient, but the difference between integer >> and DECIMAL will be less than before. > Are you referring to "operations" in the sense of comparing two > values in a SQL statement? versus simply retrieving or inserting > a value? I'd say storing and converting doesn't matter much, but currency amounts are often summed up (say for a monthly report over a huge table). For this INT should be a big win. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
