Example #1
0
        private static async Task RunPerformanceTestsAsync()
        {
            var       test       = new PerformanceTests();
            const int iterations = 500;

            Console.WriteLine("Running {0} iterations that load up a post entity", iterations);
            await test.RunAsync(iterations).ConfigureAwait(false);
        }
Example #2
0
        private static void EnsureDBSetup()
        {
            using (var cnn = PerformanceTests.GetOpenConnection())
            {
                var cmd = cnn.CreateCommand();
                cmd.CommandText = @"
if (OBJECT_ID('Posts') is null)
begin
	create table Posts
	(
		Id int identity primary key, 
		[Text] varchar(max) not null, 
		CreationDate datetime not null, 
		LastChangeDate datetime not null,
		Counter1 int,
		Counter2 int,
		Counter3 int,
		Counter4 int,
		Counter5 int,
		Counter6 int,
		Counter7 int,
		Counter8 int,
		Counter9 int
	)
	   
	set nocount on 

	declare @i int
	declare @c int

	declare @id int

	set @i = 0

	while @i <= 5001
	begin 
		
		insert Posts ([Text],CreationDate, LastChangeDate) values (replicate('x', 2000), GETDATE(), GETDATE())
		set @id = @@IDENTITY
		
		set @i = @i + 1
	end
end
";
                cmd.Connection  = cnn;
                cmd.ExecuteNonQuery();
            }
        }