Would it be faster if I had created separate tables and indexed them individually?
What is the thoughts about searching text fields for text. Is it best to store the text in a text field or is it best to tokenize out the terms and create a word table with index?
Thanks
David
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. :)
Peter
<^_^>
---------------------------------------------
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
----- Original Message -----
From: "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.
> 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
> ><^_^>
> >---------------------------------------------
> >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 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
> > > -rwxrwxrwx 1 mysql mysql 8646 Feb 14 17:32 article.frm
> > > -rwxrwxrwx 1 mysql mysql 1406663720 Feb 14 23:27 article.MYD
> > > -rwxrwxrwx 1 mysql mysql 69661696 Feb 14 23:27 article.MYI
> > >
> > > As you can see the main file is 1.4Gb
> > >
> > > The table definition is
> > > mysql> show columns from article;
> > > +-----------+--------------+------+-----+---------+-------+
> > > | Field | Type | Null | Key | Default | Extra |
> > > +-----------+--------------+------+-----+---------+-------+
> > > | ID | bigint(20) | YES | | NULL | |
> > > | id2 | bigint(20) | YES | | NULL | |
> > > | title | varchar(250) | YES | | NULL | |
> > > | body | text | YES | MUL | NULL | |
> > > +-----------+--------------+------+-----+---------+-------+
> > > 4 rows in set (0.00 sec)
> > >
> > > I'm running this on linux redhat 7.3, P500Mhz 512Mb ram -- MySQL
version
> > > 3.23.53a
> > >
> > > Thanks
> > > David
> > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > 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
> > >
> > >
>
>
> ---------------------------------------------------------------------
> 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
>
>
---------------------------------------------------------------------
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
--------------------------------------------------------------------- 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
