I'm able to index 600,000 records in about 5 to 6 minutes on a dual PII
450
running Win2K and MySQL 4.0.0a
Similar stucture
ID
Title
Description
Indexing Title and Description.
On Wed, 2002-01-09 at 20:26, Jon Shoberg wrote:
>
> I have a simple table with A LOT of data, 2.1M rows. this is purely a
> development/test/learning endeavor.
>
> The table structure is:
> ID -> auto-increment
> url -> varchar(255)
> topic -> varchar(255)
> about -> tinytext
>
>
> Anyone use fulltext indexing under this scenario? The DB server is a P3-866
> with 256mb, any guesses how long indexing will take? Its pupose could
> guiding search functionality on a website.
>
> Any comments/suggestions on using FULLTEXT ?
>
> Thanks
>
>
> ---------------------------------------------------------------------
> 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 <mysql-thread95928@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-root=aliabadi.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
