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 CH
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 CHAR
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 e
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
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.
> > > > :
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 ex
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
nt: 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 PM 2/16/2003 -0500, Peter Grigor wrote:
&
"david" <[EMAIL 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.
&
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 another coffee.
Peter
<^_^>
--
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
nday, February 16, 2003 6:00 PM
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 PROT
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
That body column wouldn't happen to be a fulltext index, would it? :)
If so, 'ave another coffee.
Peter
<^_^>
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
- Original Message -
From: "david" <[EMAIL PROTECTED]>
To: <[EMAIL PROTE
14 matches
Mail list logo
