2012年3月9日星期五

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

没有评论:

发表评论