: 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
[EMAIL PROTECTED] wrote:
From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
What is going slower, INSERT / UPDATES or SELECTS?
Complex 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
I'll second what Chris said, which is that all the joined columns
should be of the same type for speed.
Also, your substring and LIKE comparisons are going to be problematic,
as those are string operations, not numeric, and MySQL is having to
convert all the decimal values to strings before
:10 AM
To: 'Jerry Schwartz'; mysql@lists.mysql.com
Subject: RE: Speed of DECIMAL
From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
What is going slower, INSERT / UPDATES or SELECTS?
Complex SELECTs
CHAR should make for quite efficient processing, since to a
large degree nobody cares
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
-
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, October 26, 2006 4:36 AM
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
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