TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
vishal sahani
NA
92
36.5k
Bulk insert update
Jun 30 2011 1:43 AM
Hi All.
This is my first post in this forum.I am in a big problem.hope you guys can help me. I have a very large csv file like 1.71gb containing 3.5 crore records.i need to read the data & do some manipulaton & insert the records in the data base.now it is taking a very long time for the exe to reasd the file.it is only reading 12000 lines apprx in 90 mins.i need to read the data as soon as possible.i have created 8 instances & splitted the file in to smaller files..there are a total of 400 files with 85000 lines each..i have to use some joins to get other fields before inserting & aslo need to check if a particular name exists & if yes i need to updtae some field of the records.the fieds to be updated is passed dynamically..
Can any one help me.
Thanks
Reply
Answers (
5
)
Struct in C#
Generating a character serial AAAA, AAAB, AAAC