Sergei,
I wanted to say thanks so much for your help with this. I went through the
bitkeeper install, downloaded mysql 4.0, compiled under solaris 2.7, and the
process of creating the big index that took days under 3.23 took 15 minutes.
So thanks very much!
Obviously I might have tweaked some things under 3.23 and made processing
slightly faster, but this is a huge improvement, and makes the approach I
was hoping to use feasible.
thanks again,
braxton
-----Original Message-----
From: Sergei Golubchik [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 5:10 PM
To: Braxton Robbason
Cc: Mysql
Subject: Re: max FULLTEXT index size?
Hi!
On Apr 19, Braxton Robbason wrote:
> Hi all,
>
> I'm creating a fulltext index on a 400MB table, and the creation process
> gets very slow. It's fast for the first 50MB of the index, and then it
> grinds to what seemed like a halt after days. My question is - is there
> anyone who's created fulltext indexes on this much data who can assure me
> that it's possible?
>
> Merge tables are not an option because you can't query a merge table on a
> fulltext index.
>
> thanks,
> Braxton
>
Yes, FULLTEXT index works ok for 400 MB tables.
In my tests FULLTEXT index was created (with CREATE INDEX)
over 400 MB table in 15 minutes with new MySQL-4.0 code (not yet
available, sorry).
Everything works with 3.23 code too, but index creation
is 50-100 times slower (and resulting index is ~10% bigger).
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/
---------------------------------------------------------------------
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
