Alok K. Dhir ([EMAIL PROTECTED]) writes:
>
> > select * from Laws WHERE MATCH(Line) AGAINST ('growth
> > hormone') AND Line like '%growth hormone%' ORDER BY ID;
>
> This defeats the purpose of the fulltext index, don't you think?
Not really - since the WHERE clause is executed left to right, the LIKE clause is run
against the output of the MATCH clause, a much smaller subset.
I tried it - on a 250MB database containing almost 1.7 million records, the query time
went from 100+ seconds to just under 1 second - a significant increase in speed!
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc
Is your web site data driven? Are you swamped with work managing, updating,
and deploying that data on to your web site? You need Escapade! Check us
out at http://www.squishedmosquito.com/cgi-bin/esp?PAGE=esp_intro.html
---------------------------------------------------------------------
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
