At 06:57 PM 19-03-02 +0800, you wrote:

>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 <---------

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.

H.


All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________