Re: Regarding FTS and Like queries
Posted by:
Rick James
Date: January 10, 2016 05:36PM
For 44 million rows, FT will be much faster than LIKE. And do it with
where match(`value`) against ('+Hitachi +Brush +Cutter' IN BOOLEAN MODE)
Suggest you remove any "words" shorter than 3 letters and any "stop" words.
If you need to check for "Hitachi Brush Cutter" but not "Hitachi Cutter Brush", then I suggest
where match(`value`) against ('+Hitachi +Brush +Cutter' IN BOOLEAN MODE)
AND value LIKE '%Hitachi Brush Cutter%'
This is because the FT search will be fast and result in a small number of rows, which will then tediously be searched by LIKE. Net result: still very fast.
Subject
Views
Written By
Posted
3308
January 09, 2016 04:23AM
Re: Regarding FTS and Like queries
1460
January 10, 2016 05:36PM
1323
January 18, 2016 01:26AM
1427
January 18, 2016 01:54AM
1396
January 22, 2016 06:38PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.