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 ?
Hilary Cotter - 25 May 2007 17:29 GMT
Which microsoft private newsgroup would that be. You should dedicate a
minimum of 1 Gig to your OS, so cap your max sql memory at physical - 1 Gig.

Signature
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
>I have a table with 1,500,000 name and first name
> I use Full text search on name and first name
[quoted text clipped - 20 lines]
>
> could you help me ?
yonibit@gmail.com - 04 Jun 2007 11:47 GMT
I have the same problem, and someone told me that is because mssearch
process tries
to validate the signature of the connecting server (this is the reason
that you always wait about 50 sec).
You can read the full discussion at:
http://groups.google.co.il/group/microsoft.public.sqlserver.fulltext/browse_thre
ad/thread/da15555053231699/3e2a8172440473bd?lnk=st&q=sql+2005+first+time+fts+slo
w&rnum=1&hl=en#3e2a8172440473bd
But it didn't offer a real solution except running "keep alive"
process that will run a query every 20 minute.
I'll be happy to know if you found a real solution
Kent Moyle - 01 Jul 2007 06:11 GMT
You can find microsoft's kb at:
http://support.microsoft.com/kb/915850
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com