Svein Erling Tysvaer wrote:

> I've no experience with DB2 or PostgreSQL, are you saying that they can
> insert millions of records in a matter of seconds? Myself, I'm quite
> happy
> with the few thousand records a second that prepared inserts give in
> Firebird.
>
> Set
> -curious about whether we are hammered by other databases in this respect
>

By way of comparison :

Db2/Linux (Mandrake 9.0) on a PII 333Mhz with 20G IDE will do

10 million records ( 1G csv file) in 300s using LOAD.

I have an identical box running FreeBSD and firebird... I will see how
the prepared statements go ! - It will be interesting if they are just
as fast :-)

cheers

Mark