--- In firebird-support@yahoogroups.com, "Arno Brinkman"
<firebird@a...> wrote:

> Hi,
>
> > Did you've indexes on that table and how unique are the inserted
> > values?
> > I meant did you insert many duplicates.
> >
> > There were no indexes and the values were random. Does it matter

if

> > there are duplicates?
>
> Only if there is a index on it. The current (FB1.5 and lower) used

index

> does a bad job with a lot of duplicates.
>
> But, is 20 sec. on 1 000 000 really so slow? That's 50 000 records

per

> second.
> If i understand your message correct then you are already using a

prepared

> query, right?
>
> If i'm not wrong the fastest way inserting data is using a external

table.

> When you don't insert NULL states then this is possible.

It's 20 minutes not seconds. The query was prepared.