public void GlobalSetup()
{
_conn = BenchmarkEnvironment.OpenConnection();
_autoPreparingConn = new NpgsqlConnection(new NpgsqlConnectionStringBuilder(BenchmarkEnvironment.ConnectionString)
{
MaxAutoPrepare = 10
}.ToString());
_autoPreparingConn.Open();
foreach (var conn in new[] { _conn, _autoPreparingConn })
{
using (var cmd = new NpgsqlCommand {
Connection = conn
})
{
for (var i = 0; i < 100; i++)
{
cmd.CommandText = $@"
CREATE TEMP TABLE table{i} (id INT PRIMARY KEY, data INT);
INSERT INTO table{i} (id, data) VALUES (1, {i});
";
cmd.ExecuteNonQuery();
}
}
}
_query = Queries[TablesToJoin];
_preparedCmd = new NpgsqlCommand(_query, _conn);
_preparedCmd.Prepare();
}
public void Setup()
{
var conn = BenchmarkEnvironment.OpenConnection();
Command = new NpgsqlCommand($"SELECT generate_series(1, {NumRows})", conn);
Command.Prepare();
}
public GetFieldValue()
{
_conn = BenchmarkEnvironment.OpenConnection();
_cmd = new NpgsqlCommand("SELECT 0, 'str'", _conn);
_reader = _cmd.ExecuteReader();
_reader.Read();
}
public UnixDomainSocket()
{
_tcpipConn = BenchmarkEnvironment.OpenConnection();
_tcpipCmd = new NpgsqlCommand("SELECT @p", _tcpipConn);
_tcpipCmd.Parameters.AddWithValue("p", new string('x', 10000));
var port = new NpgsqlConnectionStringBuilder(BenchmarkEnvironment.ConnectionString).Port;
var candidateDirectories = new[] { "/var/run/postgresql", "/tmp" };
var dir = candidateDirectories.FirstOrDefault(d => File.Exists(Path.Combine(d, $".s.PGSQL.{port}")));
if (dir == null)
{
throw new Exception("No PostgreSQL unix domain socket was found");
}
var connString = new NpgsqlConnectionStringBuilder(BenchmarkEnvironment.ConnectionString)
{
Host = dir
}.ToString();
_unixConn = new NpgsqlConnection(connString);
_unixConn.Open();
_unixCmd = new NpgsqlCommand("SELECT @p", _unixConn);
_unixCmd.Parameters.AddWithValue("p", new string('x', 10000));
}
void GlobalSetupImpl <T>(T initializationValue)
{
_conn = BenchmarkEnvironment.OpenConnection();
_cmd = new NpgsqlCommand("SELECT @p1;", _conn);
_cmd.Parameters.AddWithValue("@p1", Enumerable.Repeat(initializationValue, NumArrayElements).ToArray());
_reader = _cmd.ExecuteReader();
_reader.Read();
}
public void Setup()
{
_conn = BenchmarkEnvironment.OpenConnection();
using (var cmd = new NpgsqlCommand("CREATE TEMP TABLE data (i1 INT, i2 INT, i3 INT, i4 INT, i5 INT, i6 INT, i7 INT, i8 INT, i9 INT, i10 INT)", _conn))
cmd.ExecuteNonQuery();
_truncateCmd = new NpgsqlCommand("TRUNCATE data", _conn);
_truncateCmd.Prepare();
}
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);
}
public void Setup()
{
_conn = BenchmarkEnvironment.OpenConnection();
using (var cmd = new NpgsqlCommand("CREATE TEMP TABLE data (i1 INT, i2 INT, i3 INT, i4 INT, i5 INT, i6 INT, i7 INT, i8 INT, i9 INT, i10 INT)", _conn))
cmd.ExecuteNonQuery();
using (var cmd = new NpgsqlCommand("INSERT INTO data VALUES (1, 2, 3, 4, 5, 6, 7, 8, 9, 10)", _conn))
for (var i = 0; i < Rows; i++)
{
cmd.ExecuteNonQuery();
}
}
public void Setup()
{
_conn = BenchmarkEnvironment.OpenConnection();
_typeMapper = (ConnectorTypeMapper)_conn.TypeMapper;
if (NumPlugins > 0)
{
_typeMapper.UseNodaTime();
}
if (NumPlugins > 1)
{
_typeMapper.UseNetTopologySuite();
}
}
public Prepare()
{
// Create tables and data
using (var conn = BenchmarkEnvironment.OpenConnection())
using (var cmd = new NpgsqlCommand {
Connection = conn
})
{
for (var i = 0; i < TablesToJoinValues.Max(); i++)
{
cmd.CommandText = $@"
DROP TABLE IF EXISTS table{i};
CREATE TABLE table{i} (id INT PRIMARY KEY, data INT);
INSERT INTO table{i} (id, data) VALUES (1, {i});
";
cmd.ExecuteNonQuery();
}
}
}
public void Setup()
{
var intArray = new int[NumElements];
for (var i = 0; i < NumElements; i++)
{
intArray[i] = 666;
}
_intConn = BenchmarkEnvironment.OpenConnection();
_intCmd = new NpgsqlCommand("SELECT @p1", _intConn);
_intCmd.Parameters.AddWithValue("p1", intArray);
_intReader = _intCmd.ExecuteReader();
_intReader.Read();
var nullableIntArray = new int?[NumElements];
for (var i = 0; i < NumElements; i++)
{
nullableIntArray[i] = AllNulls ? (int?)null : 666;
}
_nullableIntConn = BenchmarkEnvironment.OpenConnection();
_nullableIntCmd = new NpgsqlCommand("SELECT @p1", _nullableIntConn);
_nullableIntCmd.Parameters.AddWithValue("p1", nullableIntArray);
_nullableIntReader = _nullableIntCmd.ExecuteReader();
_nullableIntReader.Read();
var stringArray = new string?[NumElements];
for (var i = 0; i < NumElements; i++)
{
stringArray[i] = AllNulls ? null : "666";
}
_stringConn = BenchmarkEnvironment.OpenConnection();
_stringCmd = new NpgsqlCommand("SELECT @p1", _stringConn);
_stringCmd.Parameters.AddWithValue("p1", stringArray);
_stringReader = _stringCmd.ExecuteReader();
_stringReader.Read();
}
public Commit()
{
_conn = BenchmarkEnvironment.OpenConnection();
_cmd = new NpgsqlCommand("SELECT 1", _conn);
}
public void GlobalSetup()
{
_conn = BenchmarkEnvironment.OpenConnection();
_cmd = new NpgsqlCommand(Queries[NumColumns], _conn);
}
