Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Full text query performance

Author  Topic 

paolocosta
Starting Member

1 Post

Posted - 2009-07-06 : 10:21:14
I have a performance problem on a stored procedure that makes a full text query. When the sp is called from web site it's very slow (10 seconds), but when I test the same call from management studio it's quite fast (1 sec). The two queries run on different users.

I don't have any idea about the reason of this strange behaviour, does anyone around here has any?

Many thanks and bye

Paolo

Paolo Costa
   

- Advertisement -