sql server full text search: full text population very slow in SQL server 2000 -- sql server full text search

full text population very slow in SQL server 2000

Elian
10/2/2007 3:12:03 AM

sql server full text search:

Hi,
I have created an FTS index on a 53 milions lines table and the full
population duration was about 4 weeks and 16 Gb on the Hdd. Is this behavior
normal for this kind of size ?
my server is a Windows Server Std 2003 with 4 Gb of Ram and 2*3Ghz HT Xeon
with raid 5 hdd.

Re: full text population very slow in SQL server 2000

Hilary Cotter
10/2/2007 1:16:33 PM

It could be - I could hit 2000 rows per minute on my laptop, but you may
have more text to index. An your server is likely more powerful than my
laptop.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

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
[quoted text, click to view]