fts- contains expression: slow the first time fast the other time

fts- contains expression: slow the first time fast the other time

Post by T0xBUEZPUk » Sun, 27 May 2007 00:22:00


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 ?
 
 
 

fts- contains expression: slow the first time fast the other time

Post by Hilary Cot » Sun, 27 May 2007 01:29:23

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.

--
Looking for a SQL Server replication book?
http://www.yqcomputer.com/

Looking for a FAQ on Indexing Services/SQL FTS
http://www.yqcomputer.com/

 
 
 

fts- contains expression: slow the first time fast the other time

Post by yonibi » Tue, 05 Jun 2007 19:47:12

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://www.yqcomputer.com/ +2005+first+time+fts+slow&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
 
 
 

fts- contains expression: slow the first time fast the other time

Post by Kent » Mon, 02 Jul 2007 14:11:59

You can find microsoft's kb at:
http://www.yqcomputer.com/


EggHeadCafe.com - .NET Developer Portal of Choice
http://www.yqcomputer.com/