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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- 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