By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,379 Members | 1,396 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,379 IT Pros & Developers. It's quick & easy.

Insert more than 40,000 records

P: 40
Hi,
My requirement is to read a CSV file which has around 40,000 records and insert into DB.
I have the CSV read and stored in a collection object which is passed to the Webservice.

My client doesn't want to do abulk insert of all the records and wants to insert 1000 records at a time.

what would be the best way to do that?
1. Pass the entore colelction object to the webservice and the pass a xml stream from webservice to SQl and do a split in sql server and insert.
2. Pass 1000 records at a time from the application to the webservice and bulk insert.

Expecting replies ASAP.
thanks for ur help.
Jun 4 '08 #1
Share this Question
Share on Google+
1 Reply


debasisdas
Expert 5K+
P: 8,127
i believe the second is a better option .
Jun 4 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.