List:General Discussion« Previous MessageNext Message »
From:Amir Aliabadi Date:January 13 2002 8:05am
Subject:Re: Suggestions - FullText ??
View as plain text  
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
> 


Thread
RE: 2 GB limit reachedDennis9 Jan
  • Re: 2 GB limit reachedRandy Katz9 Jan
  • Re: 2 GB limit reachedDan Nelson9 Jan
    • Re: 2 GB limit reachedDennis9 Jan
      • Re: 2 GB limit reachedJeremy Zawodny9 Jan
    • Suggestions - FullText ??Jon Shoberg10 Jan
      • Re: Suggestions - FullText ??Amir Aliabadi13 Jan
RE: 2 GB limit reachedEric Mayers9 Jan
  • RE: 2 GB limit reachedDennis9 Jan
    • Re: 2 GB limit reachedJeremy Zawodny9 Jan
      • Re: 2 GB limit reachedDennis9 Jan
        • RE: 2 GB limit reachedJohnny Withers9 Jan
          • Re: 2 GB limit reachedChris Wilson9 Jan
    • Re: 2 GB limit reachedChris Wilson9 Jan
      • Re: 2 GB limit reachedChris Cooper9 Jan
RE: 2 GB limit reachedQuentin Bennett9 Jan
  • RE: 2 GB limit reachedDennis9 Jan
    • Re: 2 GB limit reachedDan Nelson9 Jan