Full text generating speed decreases continiously

Hi all.

I have an keyword table by 2000000 rows that is an int(4) key and a
varchar(50)
Keyword(Unique index) in Sql Server 2000.

After about 80 seconds of starting full population, speed of adding
new items t in Enterprise manager/Fulltext ctalog, decreases to (1/4)
and more less.

please help me!

Thanks"Naser_geraminia" <nsrgeraminia@.hotmail.com> wrote in message
news:a954aa7.0309111841.1346380a@.posting.google.co m...
> Hi all.
> I have an keyword table by 2000000 rows that is an int(4) key and a
> varchar(50)
> Keyword(Unique index) in Sql Server 2000.
> After about 80 seconds of starting full population, speed of adding
> new items t in Enterprise manager/Fulltext ctalog, decreases to (1/4)
> and more less.
> please help me!
> Thanks

You might want to post this in microsoft.public.sqlserver.fulltext as well -
you may get a better response there.

Simon

FTS Performance

WE have sql server 2000 with a table around 10 text field and one full-text field. over 1million rows.

How can we realize a 5 seconds or less full text query?
resuts should be order by a date field.

Note: full text field is in Chinese.

if in solution of asp: by what sentence.
if in solution of isapi, by what dev tool?nobody?