Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / July 2007

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
OLAPFOREVER - 25 May 2007 16:22 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.