What about indexes - did You created them ? I yes - what about their statistics (http://www.firebirdfaq.org/faq167/) ?

b

--- In firebird-support@yahoogroups.com, Jens Saathoff <jensesaat@...> wrote:
>
> 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
>