What is going slower, INSERT / UPDATES or SELECTS? CHAR should make for quite efficient processing, since to a large degree nobody cares what's in there: it just slams the data in, or does a simple byte-by-byte comparison. There is probably hardware support for that kind of operation. Decimal arithmetic, on the other hand, requires more data manipulations. The size of the column probably is outweighed by the more complex data handling.
No doubt someone whose internals experience is more recent than mine will chime in. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 26, 2006 4:37 AM > To: mysql@lists.mysql.com > Subject: Speed of DECIMAL > > Hi, > > I was hoping to speed up my database operations a bit by > changing some > colums in my database from CHAR(15) ASCII to DEC(15) UNSIGNED > ZEROFILL. I > was expecting a speedup as DEC(15) is more compact, and this > columns are > also part of InnoDB indices. In contrary to my expectations, > running my > test suit took approximately three times as much time, as before. > > Could anybody give me a probable reason for this slowdown? > > Thx > > ImRe > > P.S.: Ver 5.0.24a > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
