Subject | Re: [firebird-support] Re: Natural plan on indexed column |
---|---|
Author | Matthias Hanft |
Post date | 2006-03-27T14:06:56Z |
Ali Gökçen schrieb:
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
Matthias
> even you have an average machine, FB should insert 10,000 rows/s.I have tried IBExperts's "Test Data Generator". It inserts about
> it seems 100 seconds, approximatly 2 minutes to me.
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 muchYesterday, the night here was 1 hour shorter :-) (begin of DST)
> seconds took your nights in your region. ;)
Matthias