May 23, 2012 at 6:05 am
Hi All,
I build a data loading feature in our application. It will take the CSV file input and process/validate the data and insert into the sqlserver tables.
This process is running in the background using delegates concept in c#.
The process will take quite some time. currently it is taking 45 min. for inserting 150,000 with all other validations/verifications etc..
Iam not sure whether it is good response time or not. But we are ok with it for now.
But we are facing an issue when the background process is running. It is blocking all the tables that are using in this process.
So our front end application is not able to load the pages that are depended on these tables.
So, Please suggest me the precautions or methods we should take in implementing the above functionality without any issues.
Thanks,
Vijay
May 23, 2012 at 6:21 am
If your import process just inserts new records (ie it does no updates) you can insert records in a temporary table(s) and then copy all records to the real table(s) with a single instruction.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply