Re: Does this matter?

On Fri, Nov 01, 2002 at 12:53:29PM -0800, Philip Hallstrom wrote:

> > is padded out to the specified length.  Therefore the index on a char(36)
> > column will be a little larger, and thus a little slower, than the char(20).
> >
>
> Really?  According to this url (search for "Tip") there is no performance
> difference just a space difference.  I don't know for sure either way, but
> if there is a difference the manual needs updating.

Hmm.  Maybe a clarification, but I don't think this is quite what the
tip is talking about.  The tip points out that part of the cost is
"the increased storage" from the blank-padded type (char) as
contrasted with non-padded types (like text).  The tip isn't talking
about whether a length of 20 is faster than a length of 36.  Anyway,
I can't really believe the length would be a big deal except on
really huge tables.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110