> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Alan McDonald
> Sent: Wednesday, May 18, 2005 8:34 AM
> To: firebird-support@yahoogroups.com
> Subject: RE: [firebird-support] bulk insert
>
> > i'm looking for direction in terms (i hope) of existing

<snip>

> > i'm using the 1.6.3 .net provider and the 1.5.2.4731
> embedded firebird
> > engine, and am not at all oposed to changing either if it will help.
> >
> > help with either of these questions is much appreciated.
> > gabe
> >
>
> if you aren't fussed about doing it in a combination of ways,
> I would suggest you do the table creation the way you want,
> but to write the data to an external file and then issue one
> command to firebird to insert from this table to your newly
> created table. I'm sure that's the fastest way to get 2
> million records in.
> external files need to be fixed field length however, so you
> may need to pad your data as you write it to disk.

In addition, all null numeric values are stored as 0's in external
tables (last time I heard).