UC知道MSSQL全文索引提速
来源：百度知道 编辑：UC知道 时间：2024/05/30 07:26:02
我的MSSQL数据库大概120M，也没有几万的数据，但是全文索引速度特别慢，CPU占用也特别高，请问有什么办法能解决下？
我的语句：
Select Top 10 WebPageId,WebPageTitle,WebPageMain,WebPageUrl,WebPageEditTime,WebPageCount From( Select Top 10 WebPageId,WebPageTitle,WebPageMain,WebPageUrl,WebPageEditTime,WebPageCount From Zs_WebPages Where Contains(WebPageTitle,'"保定"') And Contains(WebPageMain,'"保定"') order by WebPageCount , WebPageId ) a Order By WebPageCount, WebPageId Desc
诚心请教问题，如果可以的话很希望能交个朋友，QQ569908327
我的语句：
Select Top 10 WebPageId,WebPageTitle,WebPageMain,WebPageUrl,WebPageEditTime,WebPageCount From( Select Top 10 WebPageId,WebPageTitle,WebPageMain,WebPageUrl,WebPageEditTime,WebPageCount From Zs_WebPages Where Contains(WebPageTitle,'"保定"') And Contains(WebPageMain,'"保定"') order by WebPageCount , WebPageId ) a Order By WebPageCount, WebPageId Desc
诚心请教问题，如果可以的话很希望能交个朋友，QQ569908327
这个SQL可以简化为:
Select Top 10 WebPageId,WebPageTitle,WebPageMain,WebPageUrl,WebPageEditTime,WebPageCount From Zs_WebPages Where Contains(WebPageTitle,'"保定"') And Contains(WebPageMain,'"保定"') order by WebPageCount , WebPageId
全文索引会慢?
直接换成like模糊查询看看效果是不是会好一点.
120M的数据库,像大型论坛都有数据分表的,考虑一下吧.