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

I've seen lots of people report this issue, but haven't really ever seen an
answer that is relevant for me, so any suggestions would be welcome.
I'm getting these errors reported when rebuilding all FTS catalogs on our
server.

I am fairly new with full text search. I managed to put the contains
search right. But is it possible to return the amount of keywords
found?
For example, if the keyword searching is "law", both rows:

I am adding a search functionality to my website using a full-text
index but I am running into a problem.
Currently, if a user is searching for "love and happiness", I split
the keywords down using whitespace and add NEAR in between them so it

I have a table full of part numbers VARCHAR(60) with about 3 million rows in
it. How long should the full index be taking? I've had to stop it after 5-6
hours because it's locking up the whole server.
Is there something I'm doing wrong?

I have a poorly performing full-text query and I'm wondering if there is
anything I can do to try and improve it or if the current performance is the
best I can hope for.
The query is a relatively simple CONTAINSTABLE which joins to the base table.

I am wokring on a trail version of Sql Server 2008 on Windows XP. I am
implementing full text search for one of my requirement.
Created two relational tables and populated with data
Created full text catalog with two tables

I just upgraded a server from SQL 2005 EE to SQL 2008 (x86 Win2k3EE).
I dropped the old fulltext index & catalog (I chose "Reset" on the full-text
upgrade option).
then I just recreated the catalog/index with this:

I have created a sample project to verify the full-text improvements from
SQL 2005 to SQL 2008.
Most queries run much imrpoved, but occasionally I get queries that never
finish (say, after 40 minutes).

I have a simple search engine applicaton. Everytime a search is being
made I look in the database using a simple select query if the keyword
has been searched for in the last week. If not, I then go out and
search a number of websites using a httprequest, parse out and insert

Could also be we're doing something wrong.
If we try our search specifically using "as if"...it doesn't find any
matches.
Kyle Jedrusiak