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

test/Npgsql.Benchmarks/ReadColumns.cs

72 строки2 KB

Shay Rojansky

Apply file-scoped namespaces for 6.0 (#4298)

28 янв 2022, 15:13

28 янв 2022, 15:132e0ad2d

using System.Linq;
using System.Reflection;
using System.Text;
using BenchmarkDotNet.Attributes;

namespace Npgsql.Benchmarks;

public class ReadColumns
{
    NpgsqlConnection _conn = default!;
    NpgsqlCommand _cmd = default!;

    [Params(1, 10, 100, 1000)]
    public int NumColumns { get; set; } = 100;

    static readonly string[] Queries;

    [GlobalSetup]
    public void GlobalSetup()
    {
        _conn = BenchmarkEnvironment.OpenConnection();
        _cmd = new NpgsqlCommand(Queries[NumColumns], _conn);
    }

    [GlobalCleanup]
    public void Cleanup()
    {
        _cmd.Dispose();
        _conn.Dispose();
    }

    [Benchmark]
    public int IntColumn()
    {
        unchecked
        {
            var x = 0;
            using (var reader = _cmd.ExecuteReader())
            {
                reader.Read();
                for (var i = 0; i < NumColumns; i++)
                    x += reader.GetInt32(i);
            }
            return x;
        }
    }

    static ReadColumns()
    {
        Queries = new string[NumColumnsValues.Max() + 1];
        Queries[0] = "SELECT 1 WHERE 1=0";

        foreach (var numColumns in NumColumnsValues.Where(i => i != 0))
            Queries[numColumns] = GenerateQuery(numColumns);
    }

    static string GenerateQuery(int numColumns)
    {
        var sb = new StringBuilder()
            .Append("SELECT ")
            .Append(string.Join(",", Enumerable.Range(0, numColumns)))
            .Append(";");
        return sb.ToString();
    }

    static readonly int[] NumColumnsValues = typeof(ReadColumns)
        .GetProperty(nameof(NumColumns))!
        .GetCustomAttribute<ParamsAttribute>()!
        .Values
        .Cast<int>()
        .ToArray();
}