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

test/Npgsql.Benchmarks/CommandExecuteBenchmarks.cs

62 строки2 KB

Shay Rojansky

Apply file-scoped namespaces for 6.0 (#4298)

28 янв 2022, 15:13

28 янв 2022, 15:132e0ad2d

using System;
using System.Diagnostics.CodeAnalysis;
using BenchmarkDotNet.Attributes;
using BenchmarkDotNet.Columns;
using BenchmarkDotNet.Configs;

// ReSharper disable UnusedMember.Global

namespace Npgsql.Benchmarks;

[SuppressMessage("ReSharper", "AssignNullToNotNullAttribute")]
[Config(typeof(Config))]
public class CommandExecuteBenchmarks
{
    readonly NpgsqlCommand _executeNonQueryCmd;
    readonly NpgsqlCommand _executeNonQueryWithParamCmd;
    readonly NpgsqlCommand _executeNonQueryPreparedCmd;
    readonly NpgsqlCommand _executeScalarCmd;
    readonly NpgsqlCommand _executeReaderCmd;

    public CommandExecuteBenchmarks()
    {
        var conn = BenchmarkEnvironment.OpenConnection();
        _executeNonQueryCmd = new NpgsqlCommand("SET lock_timeout = 1000", conn);
        _executeNonQueryWithParamCmd = new NpgsqlCommand("SET lock_timeout = 1000", conn);
        _executeNonQueryWithParamCmd.Parameters.AddWithValue("not_used", DBNull.Value);
        _executeNonQueryPreparedCmd = new NpgsqlCommand("SET lock_timeout = 1000", conn);
        _executeNonQueryPreparedCmd.Prepare();
        _executeScalarCmd = new NpgsqlCommand("SELECT 1", conn);
        _executeReaderCmd   = new NpgsqlCommand("SELECT 1", conn);
    }

    [Benchmark]
    public int ExecuteNonQuery() => _executeNonQueryCmd.ExecuteNonQuery();

    [Benchmark]
    public int ExecuteNonQueryWithParam() => _executeNonQueryWithParamCmd.ExecuteNonQuery();

    [Benchmark]
    public int ExecuteNonQueryPrepared() => _executeNonQueryPreparedCmd.ExecuteNonQuery();

    [Benchmark]
    public object ExecuteScalar() => _executeScalarCmd.ExecuteScalar()!;

    [Benchmark]
    public object ExecuteReader()
    {
        using (var reader = _executeReaderCmd.ExecuteReader())
        {
            reader.Read();
            return reader.GetValue(0);
        }
    }

    class Config : ManualConfig
    {
        public Config()
        {
            AddColumn(StatisticColumn.OperationsPerSecond);
        }
    }
}