Subject Re: [firebird-support] Re: Natural plan on indexed column
Author Matthias Hanft
Ali Gökçen schrieb:

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

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

> 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