I have a table with 1,500,000 name and first name
I use Full text search on name and first name
when I use a contains expression like
select ... from table1 where contains( name,'abc') the query take 45 secs
immediatly after this test I search for the same or another name and the
query take under 1 secs ....
an hour later app.. I run the same test and the first query take 45 secs again
I try a test with search 1,000,000 different name ( for validate if the
problem was the caching ).... the first on take 45 secs app and the 999,999
others case take under 1 secs
on my local computer all search run under 1 secs
Peter Yang from microsoft private news groups think that is a memory
(cache) problem... !!! but I think 45 secs is too high for a single unique
key search in link with a cache problem
could you help me ?