dev-npgsql/npgsql: Npgsql is the .NET data provider for PostgreSQL.

test/Npgsql.Benchmarks/ReadRows.cs

33 строки786 B

Shay Rojansky

Benchmark for NpgsqlDataReader.Read()

12 ноя 2017, 15:03

12 ноя 2017, 15:039e55922

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using BenchmarkDotNet.Attributes;

namespace Npgsql.Benchmarks
{
    [MemoryDiagnoser]
    public class ReadRows
    {
        [Params(1, 10, 100, 1000)]
        public int NumRows { get; set; }

        NpgsqlCommand Command { get; set; }

        [GlobalSetup]
        public void Setup()
        {
            var conn = BenchmarkEnvironment.OpenConnection();
            Command = new NpgsqlCommand($"SELECT generate_series(1, {NumRows})", conn);
            Command.Prepare();
        }

        [Benchmark]
        public void Read()
        {
            using (var reader = Command.ExecuteReader())
                while (reader.Read()) { }
        }
    }
}