Re: CREATE INDEX is sooo slow! any ideas?

Hi! On Feb 27, Sebastian Stan wrote: OK. but what about this : (AND i don't have a fulltext field !) Here's my table: (lac CHAR (3), ano CHAR (7), bno CHAR (18), cty CHAR (4), dat CHAR (8), tim CHAR (6), dur CHAR (8), ccu CHAR (8),

Re: CREATE INDEX is sooo slow! any ideas?

OK. but what about this : (AND i don't have a fulltext field !) Here's my table: (lac CHAR (3), ano CHAR (7), bno CHAR (18), cty CHAR (4), dat CHAR (8), tim CHAR (6), dur CHAR (8), ccu CHAR (8), loc CHAR (20), ccl CHAR (12), isdn

Re: CREATE INDEX is sooo slow! any ideas?

Hi! On Feb 16, Dan Nelson wrote: In the last episode (Feb 16), Michael T. Babcock said: 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

Re: CREATE INDEX is sooo slow! any ideas?

Hi! On Feb 16, david wrote: Hi I have one table with 12 million records. I'm trying to create an index on one of the fields and it's taking hours ( over 6 so far)! Am I doing something wrong? The command I issued was create index title on article ( title); The table files are

Re: CREATE INDEX is sooo slow! any ideas?

Sergei Golubchik wrote: Which decision, putting all the indexes in one file, or rebuilding all indexes whenever you ALTER TABLE or add an index? If the latter, I agree with you. Modifying unrelated indexes or columns should not force a rebuild of every index. Of course not. And it won't

CREATE INDEX is sooo slow! any ideas?

Hi I have one table with 12 million records. I'm trying to create an index on one of the fields and it's taking hours ( over 6 so far)! Am I doing something wrong? The command I issued was create index title on article ( title); The table files are -rwxrwxrwx1 mysqlmysql

Re: CREATE INDEX is sooo slow! any ideas?

] Sent: Sunday, February 16, 2003 5:47 PM Subject: CREATE INDEX is sooo slow! any ideas? Hi I have one table with 12 million records. I'm trying to create an index on one of the fields and it's taking hours ( over 6 so far)! Am I doing something wrong? The command I issued was create

Re: CREATE INDEX is sooo slow! any ideas?

Another coffee ? I'd buy Starbucks . Jerry - Original Message - From: Peter Grigor [EMAIL PROTECTED] To: [EMAIL PROTECTED]; david [EMAIL PROTECTED] Sent: Sunday, February 16, 2003 10:58 PM Subject: Re: CREATE INDEX is sooo slow! any ideas? That body column wouldn't happen

Re: CREATE INDEX is sooo slow! any ideas?

Subject: Re: CREATE INDEX is sooo slow! any ideas? Another coffee ? I'd buy Starbucks . Jerry - Original Message - From: Peter Grigor [EMAIL PROTECTED] To: [EMAIL PROTECTED]; david [EMAIL PROTECTED] Sent: Sunday, February 16, 2003 10:58 PM Subject: Re: CREATE INDEX

Re: CREATE INDEX is sooo slow! any ideas?

I meant buy the whole chain, its going to take a few cups Jerry - Original Message - From: Peter Grigor [EMAIL PROTECTED] To: Jerry [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, February 16, 2003 11:11 PM Subject: Re: CREATE INDEX is sooo slow! any ideas? Yes, and better go

Re: CREATE INDEX is sooo slow! any ideas?

^_^ - Peter Grigor Hoobly Free Classifieds http://www.hoobly.com - Original Message - From: david [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, February 16, 2003 5:47 PM Subject: CREATE INDEX is sooo slow! any ideas? Hi I have one table

Re: CREATE INDEX is sooo slow! any ideas?

PROTECTED] To: Peter Grigor [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, February 16, 2003 6:13 PM Subject: Re: CREATE INDEX is sooo slow! any ideas? Yes it is but why would that slow down index creation on the other field. The full text index is just for the body field. Thanks At 05:58

Re: CREATE INDEX is sooo slow! any ideas?

is sooo slow! any ideas? Yes it is but why would that slow down index creation on the other field. The full text index is just for the body field. Thanks At 05:58 PM 2/16/2003 -0500, Peter Grigor wrote: That body column wouldn't happen to be a fulltext index, would it? :) If so, 'ave

Re: CREATE INDEX is sooo slow! any ideas?

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

Re: CREATE INDEX is sooo slow! any ideas?

In the last episode (Feb 16), Michael T. Babcock said: 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