Sent: Friday, October 27, 2006 2: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
>
>
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 compa
[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 byte
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
ngton 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 wa
ssage -
From: <[EMAIL PROTECTED]>
To:
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 as DEC(
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
t
