List:General Discussion« Previous MessageNext Message »
From:Michael T. Babcock Date:February 17 2003 3:34am
Subject:Re: CREATE INDEX is sooo slow! any ideas?
View as plain text  
> At 06:27 PM 2/16/2003 -0500, Peter Grigor wrote:
>
>> Well, MySql stores all its index information in one index file, so 
>> when you
>> add another index it has to rebuild the WHOLE file. :)
>

Anyone on the MySQL team feel like explaining that design decision, 
besides historical reasons?  I doubt its any more efficient except in 
file descriptor usage (although I've expressed the same doubts about 
InnoDB's avoidance of the filesystem too).

SQL and all that ...

-- 
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock


Thread
CREATE INDEX is sooo slow! any ideas?david16 Feb
  • Re: CREATE INDEX is sooo slow! any ideas?Peter Grigor16 Feb
    • Re: CREATE INDEX is sooo slow! any ideas?david17 Feb
  • Re: CREATE INDEX is sooo slow! any ideas?Jerry17 Feb
  • Re: CREATE INDEX is sooo slow! any ideas?Peter Grigor17 Feb
  • Re: CREATE INDEX is sooo slow! any ideas?Jerry17 Feb
  • Re: CREATE INDEX is sooo slow! any ideas?Peter Grigor17 Feb
    • Re: CREATE INDEX is sooo slow! any ideas?david17 Feb
      • Re: CREATE INDEX is sooo slow! any ideas?Michael T. Babcock17 Feb
        • Re: CREATE INDEX is sooo slow! any ideas?Dan Nelson17 Feb
          • Re: CREATE INDEX is sooo slow! any ideas?Sergei Golubchik17 Feb
            • Re: CREATE INDEX is sooo slow! any ideas?Michael T. Babcock17 Feb
  • Re: CREATE INDEX is sooo slow! any ideas?Sergei Golubchik17 Feb
Re: CREATE INDEX is sooo slow! any ideas?Sebastian Stan27 Feb
  • Re: CREATE INDEX is sooo slow! any ideas?Sergei Golubchik27 Feb