Re: Inserting performance issue

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 24 Sep 2003 20:21:47 +0800
Message-ID: <3F718C5B.E8F@yahoo.com>

don wrote:
>
> Hi
>
> I have several batch jobs to insert a lot of data to DB, they run
> hours.
> The rate of insert varies, at begining it is slow, then it speeds up,
> sometimes dramatically, then later it slows down again.
> Is it because DB Writer wait till checkpoint to write, or what is
> exactly explanation?
>
> Thanks,
> Don

Post a statspack report from a snapshots taken from just before and just after the batch run and people will be able to assist

hth
connor Received on Wed Sep 24 2003 - 07:21:47 CDT