Subject | High CPU usage AFTER bulk insert completed |
---|---|
Author | Kenneth Foo |
Post date | 2002-03-19T10:57:38Z |
Hi
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 having
a length of less than 200 bytes), and 4 indices (including PK).
Machine spec:
Win2k,
Forced Writes=false.
320MB RAM
Celeron 450MHz (Oh yeah, machine's that old :-)
Thanks!
Regards
[Non-text portions of this message have been removed]
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 having
a length of less than 200 bytes), and 4 indices (including PK).
Machine spec:
Win2k,
Forced Writes=false.
320MB RAM
Celeron 450MHz (Oh yeah, machine's that old :-)
Thanks!
Regards
[Non-text portions of this message have been removed]