Hi Mark,

> I did wonder about this.... surely this is about the
> same as reading the
> file and inserting?
> (possibly even slower if I have to rewrite the file
> in fixed format first?)

No. I think, that this is the fastest possible way.
Converting from CSV to fixed should be very fast, as
this affects only I/O. If you're on a unix machine,
you can even mount a drive in memory - and do the
output there :-).

Here's an example on my old AMDk6-450 (old ide drives
:-).

File length of text file: 3.1 MB
record count: 100.000
insert into bla select * from tmp_table takes _20_
seconds. I don't think, that this is bad.
select (*) from tmp_table
Result: 100000

CU Chris




__________________________________________________________________

Gesendet von Yahoo! Mail - http://mail.yahoo.de
Logos und Klingeltöne fürs Handy bei http://sms.yahoo.de