public void TestReferenceParallelJoinQuery(bool changeOptions, int bufferSize, int maxConcurrency, bool changeDegree, int maxDegree) { BenchmarkConfiguration bc = BenchmarkConfiguration.Instance; bc.MinIteration = 30; bc.MaxIteration = 30; string orders = @"SELECT top 1000 c.SalesOrderId, f.SalesOrderDetailID FROM c join f in c.orderdetails"; string orderDetails = @"SELECT top 1000 * from c where IS_DEFINED(c.SalesOrderDetailID)"; foreach (var iteration in Benchmark.Iterations) { CosmosDBPerformance.ReferenceDocument h = new CosmosDBPerformance.ReferenceDocument(); using (iteration.StartMeasurement()) { h.GetReferenceData1(orders, orderDetails, changeOptions, bufferSize, maxConcurrency, changeDegree, maxDegree).GetAwaiter().GetResult(); } } }
public void TestReferenceParallelFunctionQuery(bool changeOptions, int bufferSize, int maxConcurrency, bool changeDegree, int maxDegree) { BenchmarkConfiguration bc = BenchmarkConfiguration.Instance; bc.MinIteration = 30; bc.MaxIteration = 30; string orders = @"select top 1000 CONCAT(c.SalesOrderNumber, c.AccountNumber), c.SalesOrderId from c where ENDSWITH(c.SalesOrderNumber, '4', false)"; string orderDetails = @"SELECT top 1000 * from c where IS_DEFINED(c.SalesOrderDetailID) and c.SalesOrderId='71783'"; foreach (var iteration in Benchmark.Iterations) { CosmosDBPerformance.ReferenceDocument h = new CosmosDBPerformance.ReferenceDocument(); using (iteration.StartMeasurement()) { h.GetReferenceData1(orders, orderDetails, changeOptions, bufferSize, maxConcurrency, changeDegree, maxDegree).GetAwaiter().GetResult(); } } }
public void TestReferenceParallelSumGroupQuery(bool changeOptions, int bufferSize, int maxConcurrency, bool changeDegree, int maxDegree) { BenchmarkConfiguration bc = BenchmarkConfiguration.Instance; bc.MinIteration = 30; bc.MaxIteration = 30; string orders = @"SELECT top 1000 sum(c.TotalDue), c.CustomerId,c.SalesOrderId from c group by c.CustomerId, c.SalesOrderId"; string orderDetails = @"SELECT top 1000 * from c where IS_DEFINED(c.SalesOrderDetailID) and c.SalesOrderId='71783'"; foreach (var iteration in Benchmark.Iterations) { CosmosDBPerformance.ReferenceDocument h = new CosmosDBPerformance.ReferenceDocument(); using (iteration.StartMeasurement()) { h.GetReferenceData1(orders, orderDetails, changeOptions, bufferSize, maxConcurrency, changeDegree, maxDegree).GetAwaiter().GetResult(); } } }
public void TestReferenceSimpleQuery(bool changeOptions, int buffer, int concurrency) { BenchmarkConfiguration bc = BenchmarkConfiguration.Instance; bc.MinIteration = 30; bc.MaxIteration = 30; string orders = @"SELECT top 5000 * from c where IS_DEFINED(c.CustomerId)"; string orderDetails = @"SELECT top 5000 * from c where IS_DEFINED(c.SalesOrderDetailID)"; foreach (var iteration in Benchmark.Iterations) { CosmosDBPerformance.ReferenceDocument h = new CosmosDBPerformance.ReferenceDocument(); using (iteration.StartMeasurement()) { h.GetReferenceData(orders, orderDetails, changeOptions, buffer, concurrency).GetAwaiter().GetResult(); } } }