Not only DB2 or PostgerSQL. Sybase can do it as well. Sybase has a bcc
command - line procedure, in which you specify the user name, database,
table, structure of the import file (either delimited or fixed - width) -
and can, quite literally, import millions of records in a very short space
of time.

At 10:38 AM 6/3/2003 +0200, you 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
>
>At 18:53 03.06.2003 +1200, you wrote:
> >Oh dear - I was hopping for orders of magnitude better than individual
> >inserts (prepared or not), something like Db2's LOAD or Postgresql's
> >COPY that bypasses the sql layer...so does Firebird have no "bulk load"
> >api at all? (or am I just looking at this the wrong way...?)
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.484 / Virus Database: 282 - Release Date: 5/27/2003

[Non-text portions of this message have been removed]