每15分钟执行一次自由文本搜索需要花费超过45秒的时间 [英] Freetext search taking more than 45 sec to Execute after every 15min

问题描述

我正在使用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

推荐答案

如果不查看查询/存储过程，这是一个很难回答的问题.

1)确保表上的索引正确.
2)确保您的表已正确规范化

从查询的角度来看，您可能想看一些有关SQL查询调优和性能的文章.
如果您在互联网上进行搜索，您肯定会找到一些与此相关的链接.

This is a difficult question to answer without looking at the queries / stored procedures.

1) Make sure you have the right indexes on your tables.
2) Make sure your tables are properly normalized

From a query perspective, you might want to take a look at some articles on SQL query tuning and performance.
If you do a search on the internet, you will surely find some links for this.

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