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?
Either way, do you have a feel (or access to any studies) for the impact of using DECIMAL instead of INTEGER for currency? I'd just wonder if it's enough to make up for all the required conversions going on in the app layer :-)
-- Hassan Schroeder ----------------------------- [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com
dream. code.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]