I have a scenario that inserting bulk records into sqlserver table.
Here i am validating each record-column value based on some condition.
So i have one temporary table, from that table each and every record i am moving to original table after validation.
My problem is,
when the first time i am inserting records it is ge tting loaded veryfast.It takes around 3-5 mins for 100000 records.if i insert 200000 then 10 mins .But when i am trying to insert next time ie,1000 records for the next time(means after an hour or two)it is getting very slow.
If i truncate all values from original table and started the process again ,then its loading very fast.
Why this happens?
Can anybody tell the reason?
And also help me to solve this issue.