Re: [ib-support] High CPU usage AFTER bulk insert completed
----- Original Message -----
From: "Ann W. Harrison" <aharrison@...>
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
> >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.