Printable View
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?
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! :D
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?
If it is a one time job i see no problem in taking 1h..is it going to be made everyday?
it has to be done once a month...
Its not a big problem but I rather do it quick than slow :-)
What kind of database are we talking about here? From what? To what? And why?