public decimal GetUpdateTimeStatisticsAddRangeWithDbContextRecycle(bool useDbSetToSave)
{
var fifteenThousandAddressWithoutId = MakeFifteenThousandAddress(generateIncrementalId: false);
var amazonAddressInsertLabMapper = new AmazonAddressInsertLabMapper();
var amazonAddressUpdateLabMapper = new AmazonAddressUpdateLabMapper();
var fiveThousandUpdatesTimes = new List <decimal>();
using (var amazonCodeFirstContext = new AmazonCodeFirstDbContext())
{
amazonAddressInsertLabMapper.CleanAddressData(amazonCodeFirstContext);
}
amazonAddressInsertLabMapper.InsertAddressWithDbSetWithAddRange(fifteenThousandAddressWithoutId);
for (int i = 0; i < 3; i++)
{
var fiveThousandAddress = MakeFiveThousandAddress((i * 5000) + 4);
using (var amazonCodeFirstContext = new AmazonCodeFirstDbContext())
{
var fiveThousandUpdateTime = useDbSetToSave
? amazonAddressUpdateLabMapper.UpdateAddressWithDbSetWithAddRange(amazonCodeFirstContext, fiveThousandAddress)
: amazonAddressUpdateLabMapper.UpdateAddressWithDbContextWithAddRange(amazonCodeFirstContext, fiveThousandAddress);
fiveThousandUpdatesTimes.Add(fiveThousandUpdateTime);
}
}
var fiveThousandUpdateTimeAverage = Enumerable.Average(fiveThousandUpdatesTimes);
var insertTime = decimal.Divide(fiveThousandUpdateTimeAverage, 5_000);
return(insertTime);
}
public decimal GetUpdateTimeWithBulkOperation()
{
var fifteenThousandAddressWithoutId = MakeFifteenThousandAddress(generateIncrementalId: false);
var fifteenThousandAddressIlist = MakeFifteenThousandAddressIlist();
var amazonAddressInsertLabMapper = new AmazonAddressInsertLabMapper();
var amazonAddressUpdateLabMapper = new AmazonAddressUpdateLabMapper();
amazonAddressInsertLabMapper.CleanAddressData();
amazonAddressInsertLabMapper.InsertAddressWithDbSetWithAddRange(fifteenThousandAddressWithoutId);
var updateTimeAllRecords = amazonAddressUpdateLabMapper.UpdateAddressWithBulkOperation(fifteenThousandAddressIlist);
var updateTime = decimal.Divide(updateTimeAllRecords, fifteenThousandAddressIlist.Count());
return(updateTime);
}
public decimal GetUpdateTimeStatisticsAddRange(bool useDbSetToSave)
{
var fifteenThousandAddressWithoutId = MakeFifteenThousandAddress(generateIncrementalId: false);
var fifteenThousandAddress = MakeFifteenThousandAddress(generateIncrementalId: true);
var amazonAddressInsertLabMapper = new AmazonAddressInsertLabMapper();
var amazonAddressUpdateLabMapper = new AmazonAddressUpdateLabMapper();
using (var amazonCodeFirstContext = new AmazonCodeFirstDbContext())
{
amazonAddressInsertLabMapper.CleanAddressData(amazonCodeFirstContext);
amazonAddressInsertLabMapper.InsertAddressWithDbSetWithAddRange(fifteenThousandAddressWithoutId);
var updateTimeAllRecords = useDbSetToSave
? amazonAddressUpdateLabMapper.UpdateAddressWithDbSetWithAddRange(fifteenThousandAddress)
: amazonAddressUpdateLabMapper.UpdateAddressWithDbContextWithAddRange(fifteenThousandAddress);
var updateTime = decimal.Divide(updateTimeAllRecords, fifteenThousandAddress.Count());
return(updateTime);
}
}
public UpdateTimeStatistics GetUpdateTimeStatisticsWithDbContextRecycle(bool useDbSetToSave)
{
var updateTimeStatistics = new UpdateTimeStatistics();
var rowsUpdated = 0;
var fifteenThousandAddressWithoutId = MakeFifteenThousandAddress(generateIncrementalId: false);
var fifteenThousandAddress = MakeFifteenThousandAddress(generateIncrementalId: true);
var rowCutOffToEmptyTable = Faker.RandomNumber.Next(5, 100);
var rowCutOffToTableWithFiveThousandRows = Faker.RandomNumber.Next(6_000, 9_000);
var rowCutOffToTableWithTenThousandRows = Faker.RandomNumber.Next(11_000, 14_000);
var tenUpdateTimes = new List <long>();
var amazonAddressInsertLabMapper = new AmazonAddressInsertLabMapper();
var amazonAddressUpdateLabMapper = new AmazonAddressUpdateLabMapper();
using (var amazonCodeFirstContext = new AmazonCodeFirstDbContext())
{
amazonAddressInsertLabMapper.CleanAddressData(amazonCodeFirstContext);
amazonAddressInsertLabMapper.InsertAddressWithDbSetWithAddRange(fifteenThousandAddressWithoutId);
foreach (var address in fifteenThousandAddress)
{
address.Street = "Updated Street";
var updateTime = useDbSetToSave
? amazonAddressUpdateLabMapper.UpdateAddressWithDbSet(address)
: amazonAddressUpdateLabMapper.UpdateAddressWithDbContext(address);
rowsUpdated++;
if (IsRowToBeComputed(rowsUpdated, rowCutOffToEmptyTable))
{
tenUpdateTimes.Add(updateTime);
if (tenUpdateTimes.Count == _tenRegisters)
{
var updateTimesAverage = Enumerable.Average(tenUpdateTimes);
updateTimeStatistics.MillisecondsAverageBasedOnTenUpdatesWithEmptyTable = updateTimesAverage;
tenUpdateTimes.Clear();
}
}
if (IsRowToBeComputed(rowsUpdated, rowCutOffToTableWithFiveThousandRows))
{
tenUpdateTimes.Add(updateTime);
if (tenUpdateTimes.Count == _tenRegisters)
{
var updateTimesAverage = Enumerable.Average(tenUpdateTimes);
updateTimeStatistics.MillisecondsAverageBasedOnTenUpdatesWithTableWithFiveThousandsRows = updateTimesAverage;
tenUpdateTimes.Clear();
}
}
if (IsRowToBeComputed(rowsUpdated, rowCutOffToTableWithTenThousandRows))
{
tenUpdateTimes.Add(updateTime);
if (tenUpdateTimes.Count == _tenRegisters)
{
var updateTimesAverage = Enumerable.Average(tenUpdateTimes);
updateTimeStatistics.MillisecondsAverageBasedOnTenUpdatesWithTableWithTenThousandsRows = updateTimesAverage;
tenUpdateTimes.Clear();
}
}
}
}
return(updateTimeStatistics);
}
