Subject | Re: Looking for a fast solution for loading data from a text file into Firebird |
---|---|
Author | vladman992000 |
Post date | 2009-02-19T15:39:12Z |
--- In firebird-support@yahoogroups.com, Milan Babuskov <milanb@...>
wrote:
No, its not currently fixed width. I don't have any control over the
source data being uploaded (as I would lose all the performance gain
in trying to pad the data anyway). What is the impact of using a
non-fixed width file here?
The file, for example, looks like this:
jsmith@...
benedict@...
bill@...
etc.
Myles
wrote:
> Is it fixed-width? If yes, using an external table is the fastest way.Thanks Milan,
No, its not currently fixed width. I don't have any control over the
source data being uploaded (as I would lose all the performance gain
in trying to pad the data anyway). What is the impact of using a
non-fixed width file here?
The file, for example, looks like this:
jsmith@...
benedict@...
bill@...
etc.
Myles