> start several threads (e.g. 4 or 8) each writing 2000 (simple)
> records to the database. Running only one thread I can write approx
> 500 records a second however as soon as I run several threads the
> owerall speed drops to below 200. I did a quick conversion of my
> test program to use IBX in stead of IBO and here the speed stays
> around (a total) of 500 records per second even when I run 4 or 8
> threads at the same time (I normally use IBO, however have not used
> it "threaded" before - therefor the "need" to test it with IBX).

I've discovered the same problem using RemObjects and IBO with the
native components (with IBX -> no problem). If there are more than
one instance is running, the performance decreased heavily. The
kernel-cpu-time goes up to 50% ?!

The RO module does a lot of record processing like this

select * from x
while Eof = false do begin
FieldByName...
Next
end

BUT: The problem only occurs, if the application is running on
a SMP maschine.

using Firebird 1.5RC6 SS, IBO 4.2Hc, W2k SP3

--
marco krause