每15分钟执行一次自由文本搜索需要花费超过45秒的时间

问题描述

我正在使用sqlserver 2005.我使用自由文本创建了一个搜索过程，一切正常，但是每15分钟执行一次该过程将花费超过45秒的时间.请帮助我解决
这个问题.

I am using sqlserver 2005 . I create a search proc using freetext, every thing is working fine but after every 15 min the proc take more than 45 sec to execute .Please help me to solve
this problem.

ALTER PROCEDURE [dbo].[sp_ftsearchOnResumetbl]
(
	@StructuredXMLResume_ExecutiveSummary							NVARCHAR(100),
	@StructuredXMLResume_Qualifications_QualificationSummary		NVARCHAR(100)
)
AS
BEGIN
DECLARE @searchWord NVARCHAR(200)
	SET @searchWord= @StructuredXMLResume_ExecutiveSummary 
               +'' ''+@StructuredXMLResume_Qualifications_QualificationSummary
	BEGIN TRY
		SELECT ResumeId,StructuredXMLResume_ExecutiveSummary as 
                Exesummary,StructuredXMLResume_Qualifications_QualificationSummary as Qualifications FROM Resume
		INNER JOIN FREETEXTTABLE(Resume, 
             StructuredXMLResume_ExecutiveSummary,StructuredXMLResume_Qualifications_QualificationSummary),@searchWord) 
              AS KEY_TBL
		ON ResumeId=KEY_TBL.[KEY]
	END TRY
	BEGIN CATCH
		RETURN 1
	END CATCH
END

谢谢，
Partha

Thanks,
Partha

推荐答案

这篇关于每15分钟执行一次自由文本搜索需要花费超过45秒的时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！