On Thu, Nov 08, 2001 at 05:46:35PM -0500, Tony wrote:
> On Thursday 08 November 2001 10:55 am, Paul DuBois wrote:
> > At 10:00 AM -0500 11/8/01, Tony wrote:
> > >Does anyone know if putting (or grouping) varchar columns at the end of a
> > >table provides any performance improvements? My indices are all integers,
> > >but not have varchar columns in between several integer columns.
> >
> > You'll get a speed improvement only if all your columns are fixed length.
> > Otherwise the table has variable length rows, no matter the placement
> > of the variable length coluumns.
> >
>
> So then is the real purpose of using varchars, to save disk space? ( I
> realize this is probably a general database question, just trying to learn).
+ your datafile will be smaller which saves disk IO. In the end, the extra
cost of the less efficient index as less than the gain from the faster
access. So in the end you win speed.
But, it is all explaind in the manual :)
(sql, etc)
--
The Moon is Waning Crescent (45% of Full)
nieuw.nl - 2dehands.nl: 14523
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
