From: "Geoff Coffey" <[EMAIL PROTECTED]>
Sent: Thursday, February 01, 2001 5:25 PM
> I am in the process of migrating a site built with FileMaker Pro to MySQL
> and PHP mostly because filemaker's web capabilities are too limiting. In
one
> situation, we have a database of about 20,000 rows that contains two text
> columns. One is the full text of a resume and the other is the full text
of
> a cover letter. I'm trying to decide how to enable searching from a web
> form.
<snip>
> I also saw mention of a FULL-TEXT index. Is anybody using this? I think it
> would be a good bet, if I can get 3.23 to build on our setup, and if it is
> stable. It would certainly save me lots of trouble...
I would definately go for the FULLTEXT index. Using LIKE statements as in
"WHERE a LIKE '%someword%' ..." always causes the DB to make a sequential
scan - not good.
I'm using FULLTEXT myself - on a table with about 4.2 MB text, it generates
an index file with a size around 2 MB.
Only downside I find with the FULLTEXT is that you cannot search for
'someword%' - but it's a price I have no problem paying.
- Carsten
---------------------------------------------------------------------
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
