|
-
Jan 31st, 2004, 08:40 AM
#1
Thread Starter
Junior Member
INSERT 1000000 post into DB
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote