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.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info