I've been looking hard at the FULLTEXT features of MySQL 4.0.1 on Linux and 4.0.0a on Win32 and comparing it to MS SQL 2000 / and MS SQL 7.0 as well as MySQL 3.XX.XX (latest stable release).
MySQL 4 on Win2K (dual 550 1gig memory) can crawl 90MB of data in about 5 minutes . MS SQL 7 and 2000 on the same machine take about 3.5 to 4 hours. MySQL 3.XX (the latest stable don't know the exact version off the top of my head) took about 6 hours to craw the 90MB of data. Some FULLTEXT seaches agains the MySQL 4.0 database where substantially slower than MS SQL. Bulk deletes from a table that has a FULLTEXT index seems to curropt the table on Win32. This does not seem to be the case on MySQL 4.0.1 running on Linux. On Thu, 2002-01-03 at 04:33, Haapanen, Tom wrote: > And, alas, by the time MySQL finishes building my 500 MB fulltext index > (more than 12 hours) the table is throroughly corrupted, and myisamchk can't > even recover it with -o. > > I'm waiting for 4.01 to go beta, and will then give it a try to see if > things are happier there. > > Tom Haapanen > [EMAIL PROTECTED] > > -----Original Message----- > From: Steve Rapaport [mailto:[EMAIL PROTECTED]] > Sent: 03 January 2002 04:39 > To: Neil Tompkins > Cc: [EMAIL PROTECTED] > Subject: Re: Full Search > > > Yes, you can add a FULLTEXT index to that table including all 15 fields, > e.g. > CREATE FULLTEXT INDEX findtext ON mytable (field1, field2, > field3,...field15); > > Caveats: > The fields must be of type VARCHAR or TEXT to work, (CHAR can be changed to > VARCHAR easily, and often is silently changed.) > > Depending on the table size and other things, creating this index can > be very slow, taking hours or even days. Try in advance to limit the > size and number of fields in the index to what you really want, and > don't plan on re-indexing very often. > > Steve. > > Neil Tompkins wrote: > > > I have a mySQL table which has about 15 fields. Is it possible using a > > standard SQL statement to do a full text search on all fields ?? > > > -- > Steve Rapaport > World Citizen > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
