i have table with 15 columns and non-clustered index in sql server.
i am inserting some data in files with bulkinsert statement in dot net.
all files with equal records
for first file it took around 5 mins
for 2nd file it took around 10 mins
3rd 15m, 4th 20m and so on....
i dont know, why time in increasing constantly?
is there any alternate?
c# dot net application with sql server