mysql levenshtein_mysql – levenshtein替代方案

最新推荐文章于 2024-03-14 11:32:04 发布

weixin_39596975

最新推荐文章于 2024-03-14 11:32:04 发布

阅读量228

点赞数

文章标签： mysql levenshtein

本文链接：https://blog.csdn.net/weixin_39596975/article/details/113592476

版权

我有一大堆查询并使用levenshtein计算拼写错误,现在levenshtein导致mysql占用完整的cpu时间.

我的查询是UNION语句中的全文搜索levenshtein.

sql1是我当前的查询,sql2只是全文搜索,这是快速的,并没有使用太多的cpu时间,最后一个leventhein一个将达到峰值！

你们中的任何人都有另一种方式来获取拼写错误吗？

请不要回答规范化数据,我已经想到了,但不适用于我的数据,因为我不能预先进行匹配/计算并创建一个带索引的单独表.

$sql1 = "(SELECT * FROM ci_sanctions_properties WHERE prop_type='LASTNAME' AND prop_value!='' AND MATCH(prop_value) AGAINST ('+usama bin laden' IN BOOLEAN MODE)) UNION (SELECT s.* FROM (SELECT levenshtein(prop_value,'usama bin laden') AS dist,sanction_id,prop_type,prop_value FROM ci_sanctions_properties WHERE prop_type='LASTNAME' AND prop_value!='') s WHERE dist < 3) ORDER BY sanction_id";

$sql2 = "SELECT * FROM ci_sanctions_properties WHERE prop_type='LASTNAME' AND prop_value!='' AND MATCH(prop_value) AGAINST ('+usama bin laden' IN BOOLEAN MODE) ORDER BY sanction_id";

$sql3 = "SELECT s.* FROM (SELECT levenshtein(prop_value,prop_value FROM ci_sanctions_properties WHERE prop_type='LASTNAME' AND prop_value!='') s WHERE dist < 3";