Hi,

> > even you have an average machine, FB should insert 10,000

rows/s.

> > it seems 100 seconds, approximatly 2 minutes to me.
>
> I have tried IBExperts's "Test Data Generator". It inserts about
> 100 rows/s in my case.
>

Oh! it must be a real tragedy!!! :))
i never got this deep score, even with 8088 computers day with 16b
applications.

> I can imagine two "breaks" in my environment:
> a) the database has some indexes which are active while inserting
> (and you can't deactivate the primary key, can you?)
> b) Firebird and IBExpert run on different computers which are
> connected by a 100 Mbit/s switch

it doesn't effect so much.
don't to accuse primary index rapidly, my example performance was
about indexed table.

what is your record size?
what are you saving in rows? divx film, mp3, mp4, jpg blobs?

i think you have some problems with your HW or SW systems other than
FB.
100 Mb means, more than 12MB second. even you have 1KB rows, you can
send 10,000 rows per second in the lonely nights, not 100!

>
> > anyway, i have no idea about your local timing system and how

much

> > seconds took your nights in your region. ;)
>
> Yesterday, the night here was 1 hour shorter :-) (begin of DST)
>
> Matthias
>

Yup, i know, i was late 1(regular)+1 hours to work. ;)

Ali

Patient of Firebirdmanicaggressive&
Firebird Foundation Member #208