Subject Re: [ib-support] High CPU usage AFTER bulk insert completed
Author Kenneth Foo
----- Original Message -----
From: "Ann W. Harrison" <aharrison@...>
To: <>
Sent: Thursday, March 21, 2002 1:08 AM
Subject: Re: [ib-support] High CPU usage AFTER bulk insert completed

> Are you also doing a commit after each insert? That's making things
> slower than they need to be ... at least in most cases.

Yes, I did. :-)

I have a system that sends out messages and store some information in a DB
to keep track of messages that has been sent. In case of a server crash,
the system needs to know where it left off, thus the need for commits often.
Basically, I was testing the average sustained rate of insertion for FB.

But I didn't expect the processor usage to linger even after the operation
I thought once commit has been performed, there aren't any more significant
cpu-intensive operations to perform?

> >Just wondering if this has something to do with some internal memory
> >management?
> >But then again, it's just 2000 prepared statements. It can't possibly
> >25 seconds to free them all right?
> Have you traced the memory usage of the server?

Well, I think it goes up till 144Mb, according to Windows Task Manager.
This on a machine with 384Mb RAM.