Re: Suggestions - FullText ??

2002-01-12 Thread Amir Aliabadi
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

Suggestions - FullText ??

2002-01-09 Thread Jon Shoberg
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