Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
Best Approach to Save Data into SQL Server?
Ashish Vishwakarma
Mar 23 2016 1:15 AM
384
Reply
I have few records to save into database, approx 12 KB each. They are coming as bunch of 10 to 15 Records. I have option of 2 approaches to follow.
1. Iterating Records in C# and sending them one by one to Database to save. (10 to 15 requests to DB 12 KB each).
2. Pushing all records at once in DB, and let the stored procedure do the Jobs of Iterating and saving each record. (Only one request to DB 120KB to 180KB).
This is gonna be used in a job which is configured to run everyday midnight. Please suggest which is approach is better and why?
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
Windows service to insert files in tables at timers.
how to avoid to insert duplicate data in db.