Re: InnoDB and ALTER TABLE ... ORDER BY

2002-11-27 Thread Jeremy Zawodny 
On Wed, Nov 27, 2002 at 03:04:25PM -0800, Steven Roussey wrote:
>
> Does InnoDB support ALTER TABLE ... ORDER BY ...?

No.

> If it weren't for this command, we would never get the continuous
> great performance we get from MySQL. And it keeps us from ever
> really considering InnoDB. :(

Records in InnoDB are ordered based on the primary key, using
clustered indexing IIRC.

Jeremy
-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 3.23.51: up 7 days, processed 251,342,622 queries (382/sec. avg)

-
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

InnoDB and ALTER TABLE ... ORDER BY

2002-11-27 Thread Steven Roussey 
Does InnoDB support ALTER TABLE ... ORDER BY ...? If it weren't for this
command, we would never get the continuous great performance we get from
MySQL. And it keeps us from ever really considering InnoDB. :(

Sincerely,
Steven Roussey
http://Network54.com/ 




-
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