Full Text Query - 1st Execution Time

Hi,
I have an issue with the full text query
The first execution time takes 40 – 45 seconds for a table that only has 4
rows!
While executing the query for the second, third, etc… time completes with
milliseconds.

If I leave the query for a while and then execute it, it also takes 40
seconds.

Please help.

This is the most common cause of this issue:
http://support.microsoft.com/kb/915850

--

========
Michael Coles
"Pro T-SQL 2008 Programmer's Guide"
http://www.amazon.com/T-SQL-2008-Programmer-rsquo-Guide/dp/143021001X


"RATA" wrote in message

> Hi,
> I have an issue with the full text query
> The first execution time takes 40 - 45 seconds for a table that only has 4
> rows!
> While executing the query for the second, third, etc. time completes with
> milliseconds.
>
> If I leave the query for a while and then execute it, it also takes 40
> seconds.
>
> Please help.
>