I have installed full text searching on a table on Sql 2000 (sp4 is
installed).
It is hanging while it is indexing. I have the re-indexing set at
every 10 minutes.
Any ideas?
Thanks,
Marc
Is there a lot of activity on this table? Expect locking if the table is
heavily updated. Try to run profiler to give you hints as to what is
occurring on the table during the population. Also what sort of population
are you running? I think you will find that change tracking offers the best
performance.
Hilary Cotter
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
"Marc" <Marc@.discussions.microsoft.com> wrote in message
news:E9D4E872-A2C3-4176-9210-A0BA654A126B@.microsoft.com...
> I have installed full text searching on a table on Sql 2000 (sp4 is
> installed).
> It is hanging while it is indexing. I have the re-indexing set at
> every 10 minutes.
> Any ideas?
> Thanks,
> Marc
>
没有评论:
发表评论