Subject | My Firebird-DB is getting slow after inserting 150.000 records |
---|---|
Author | Jens Saathoff |
Post date | 2010-11-05T15:18:57Z |
Hi!
I'm very new here. I'm programming an App with C++ and IBPP as
firebird-Interface. Used firebird is 2.1 (embedded server).
My problem is that i'm importing some data into firebird and after
inserting 150.000 records in different tables the inserts are slow.
For each record i have to select id from 4 different tables for
foreign keys. SELECT and inserts are mixed. Is that a problem for
firebird? selecting, inserting selecting ? The commit.
Thanks for your help.
Jens S
I'm very new here. I'm programming an App with C++ and IBPP as
firebird-Interface. Used firebird is 2.1 (embedded server).
My problem is that i'm importing some data into firebird and after
inserting 150.000 records in different tables the inserts are slow.
For each record i have to select id from 4 different tables for
foreign keys. SELECT and inserts are mixed. Is that a problem for
firebird? selecting, inserting selecting ? The commit.
Thanks for your help.
Jens S