INSERT 1000000 post into DB

[ost]

Hi

I have a textfile with 1000000 lines and i need to INSERT these into a database.

The keyword here is performance. I have tried to read a line and doing an INSERT for each line.. This means 1000000 executenonquery calls and it would take about 1 hour to do this import.

Anyone have other ideas on how to do this?

[salvelinus]

A million entries in the table??? entered at once??? This may be more of a hardware or type of db issue. Maybe VB isn't the best language for this type of operation. C or ASM might be better suited. Heck, code straight to binary!
Seriously, this may be beyond VB's capacity.
If you can, rethink the design. Can the lines be INSERTed as they're generated, or as a smaller batch? Why do 1 million separate entries have to be inserted at once?

[PT Exorcist]

If it is a one time job i see no problem in taking 1h..is it going to be made everyday?

[ost]

it has to be done once a month...

Its not a big problem but I rather do it quick than slow :-)

[Edneeis]

What kind of database are we talking about here? From what? To what? And why?