List:General Discussion« Previous MessageNext Message »
From:Jon Shoberg Date:January 10 2002 4:26am
Subject:Suggestions - FullText ??
View as plain text  
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

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