Subject Re: [ib-support] High CPU usage AFTER bulk insert completed
Author Helen Borrie
At 06:57 PM 19-03-02 +0800, you wrote:
>After my application is done performing roughly 3000 inserts into a database,
>ibserver.exe seems to be hogging the processor power for about 30 seconds.
>Hard disk access is minimal.
>I'm just curious what IB is doing, as I don't notice this kind of behavious
>in other databases that I've worked with before.
>Have I missed some configuration settings or something?
>The table consists of several columns of short BLOBs. (about 4 or so, each
>a length of less than 200 bytes), and 4 indices (including PK).
>Machine spec:
>Forced Writes=false <---------

30 seconds sounds like a reasonable time to hog the CPU while committing
12,000 blobs to the disk cache...2.5 millisecs per blob.


All for Open and Open for All
Firebird Open SQL Database · ·