473,320 Members | 2,006 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Does FullText warning mean any update to text field will not be reflected?

Hi all,

Maybe this belongs in the Full Text group but I am writing an ASP.NET
application with a SQL Server 2005 backend, so I am posing the question
here.

I have been using fulltext search on a text field for a while because
originally the field was only being updated nightly and I could
repopulate/rebuild the index nightly. Now I will be allowing users to Update
the field in real-time. I am using a simple Update SQL statement to modify
the contents of that field.

Does the warning below mean that a fulltext search performed on the field
after a simple Update will not reflect the changes?

I would hate to have to go back to a LIKE syntax on the field as CONTAINS
seems to work better and faster, especially when multiple keywords are used
in the search.

The syntax I used to create the index is as follows:
--------------------------------------------------
CREATE FULLTEXT INDEX ON dbo.List_Summary (summary, List_Name1 )
KEY INDEX PK_List_Summary ON PCFullTextCatalog
WITH CHANGE_TRACKING AUTO

Warning: Table or indexed view 'dbo.List_Summary' has full-text indexed
columns that are of type image, text, or ntext. Full-text change tracking
cannot track WRITETEXT or UPDATETEXT operations performed on these columns.
-------------------------------------------------

Do I have a problem here by allowing real-time Updates of the text field? If
so, is there a way to make sure the index gets updated after the Update
statement?

There may be as many as 20 or 30 users running searches simultaneously, so
of course I am concerned about concurrency if I must rebuild the index with
every update.

Thanks for any help with this.

Jun 27 '08 #1
2 2880
it means if you use writetext or update text staments (which allow partial
updates of the field data) then the index is not update. if you use insert or
update statements then the index is updated.

-- bruce (sqlwork.com)
"John Kotuby" wrote:
Hi all,

Maybe this belongs in the Full Text group but I am writing an ASP.NET
application with a SQL Server 2005 backend, so I am posing the question
here.

I have been using fulltext search on a text field for a while because
originally the field was only being updated nightly and I could
repopulate/rebuild the index nightly. Now I will be allowing users to Update
the field in real-time. I am using a simple Update SQL statement to modify
the contents of that field.

Does the warning below mean that a fulltext search performed on the field
after a simple Update will not reflect the changes?

I would hate to have to go back to a LIKE syntax on the field as CONTAINS
seems to work better and faster, especially when multiple keywords are used
in the search.

The syntax I used to create the index is as follows:
--------------------------------------------------
CREATE FULLTEXT INDEX ON dbo.List_Summary (summary, List_Name1 )
KEY INDEX PK_List_Summary ON PCFullTextCatalog
WITH CHANGE_TRACKING AUTO

Warning: Table or indexed view 'dbo.List_Summary' has full-text indexed
columns that are of type image, text, or ntext. Full-text change tracking
cannot track WRITETEXT or UPDATETEXT operations performed on these columns.
-------------------------------------------------

Do I have a problem here by allowing real-time Updates of the text field? If
so, is there a way to make sure the index gets updated after the Update
statement?

There may be as many as 20 or 30 users running searches simultaneously, so
of course I am concerned about concurrency if I must rebuild the index with
every update.

Thanks for any help with this.

Jun 27 '08 #2
Thanks Bruce,
that is what I was hoping for.
"bruce barker" <br*********@discussions.microsoft.comwrote in message
news:CE**********************************@microsof t.com...
it means if you use writetext or update text staments (which allow partial
updates of the field data) then the index is not update. if you use insert
or
update statements then the index is updated.

-- bruce (sqlwork.com)
"John Kotuby" wrote:
>Hi all,

Maybe this belongs in the Full Text group but I am writing an ASP.NET
application with a SQL Server 2005 backend, so I am posing the question
here.

I have been using fulltext search on a text field for a while because
originally the field was only being updated nightly and I could
repopulate/rebuild the index nightly. Now I will be allowing users to
Update
the field in real-time. I am using a simple Update SQL statement to
modify
the contents of that field.

Does the warning below mean that a fulltext search performed on the field
after a simple Update will not reflect the changes?

I would hate to have to go back to a LIKE syntax on the field as CONTAINS
seems to work better and faster, especially when multiple keywords are
used
in the search.

The syntax I used to create the index is as follows:
--------------------------------------------------
CREATE FULLTEXT INDEX ON dbo.List_Summary (summary, List_Name1 )
KEY INDEX PK_List_Summary ON PCFullTextCatalog
WITH CHANGE_TRACKING AUTO

Warning: Table or indexed view 'dbo.List_Summary' has full-text indexed
columns that are of type image, text, or ntext. Full-text change tracking
cannot track WRITETEXT or UPDATETEXT operations performed on these
columns.
-------------------------------------------------

Do I have a problem here by allowing real-time Updates of the text field?
If
so, is there a way to make sure the index gets updated after the Update
statement?

There may be as many as 20 or 30 users running searches simultaneously,
so
of course I am concerned about concurrency if I must rebuild the index
with
every update.

Thanks for any help with this.

Jun 27 '08 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Phil Powell | last post by:
Based upon the following articles: http://www.experts-exchange.com/Web/Web_Languages/PHP/Q_20708448.html http://www.experts-exchange.com/Web/Web_Languages/PHP/Q_20717295.html...
2
by: Phil Powell | last post by:
Relevancy scores are normally defined by a MySQL query on a table that has a fulltext index. The rules for relevancy scoring will exclude certain words due to their being too short (minimum...
0
by: Phil Powell | last post by:
The table already has a fulltext index and from there I can use the MySQL fulltext search query to get results as well as the relevancy score. The problem I have is that MySQL has a default...
12
by: Fred Pacquier | last post by:
First off, sorry for this message-in-a-bottle-like post... I haven't been able to phrase my questions well enough to get a meaningful answer from Google in my research. OTOH, it is standard...
0
by: Henry Hank | last post by:
Environment: I'm setting up a database server on a Dell Poweredge 2650, dual 1.8GHZ pentium with 1GB of memory and RAID5 drives. I've installed RedHat 9, and updated the kernel to 2.4.20-19.9smp....
0
by: Matt W | last post by:
Hi all, I'm planning to use MySQL's full-text search for my forum system (possibly 5+ million posts). I've been playing with it a lot lately to see the performance and functionality and have...
0
by: Alex Glass | last post by:
I have a large contacts table with about 30 columns of text fields and 5 fulltext indexes spanning the different sections of the table. I'm curious if anyone could suggest a better way to find...
6
by: lawrence k | last post by:
Wierd. Go to this page: http://www.ihanuman.com/search.php and search for "yoga" This query gets run: SELECT * FROM albums WHERE MATCH(name,description) AGAINST ('yoga') ORDER BY id DESC
4
by: cody | last post by:
It is possible to declare and use/instantiate a class with a uninitialized readonly field without even a compiler warning. Why don't I get warnings? public class Stuff { public readonly int a;...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.