public void AdoNetOnly()
{
for (int n = 2; n < 4000; n *= 2)
{
Simple[] simples = new Simple[n];
for (int i = 0; i < n; i++)
{
simples[i] = new Simple();
simples[i].Init();
simples[i].Count = i;
simples[i].Id = i;
}
//Now do timings
Timer timer = new Timer();
IDbConnection _connection = sqlMap.DataSource.DbProvider.CreateConnection();
_connection.ConnectionString = sqlMap.DataSource.ConnectionString;
_connection.Open();
timer.Start();
DirectAdoNet(_connection, simples, n, "j1");
timer.Stop();
double adonet = 1000000 * (timer.Duration / (double)n);
_connection.Close();
_connection.Open();
timer.Start();
DirectAdoNet(_connection, simples, n, "j2");
timer.Stop();
adonet += 1000000 * (timer.Duration / (double)n);
_connection.Close();
_connection.Open();
timer.Start();
DirectAdoNet(_connection, simples, n, "j2");
timer.Stop();
adonet += 1000000 * (timer.Duration / (double)n);
_connection.Close();
System.Console.Out.WriteLine("Objects: " + n + " Direct ADO.NET: " + adonet.ToString("F3"));
}
System.GC.Collect();
}
public void IbatisOnly()
{
for (int n = 2; n < 4000; n *= 2)
{
Simple[] simples = new Simple[n];
object[] ids = new object[n];
for (int i = 0; i < n; i++)
{
simples[i] = new Simple();
simples[i].Init();
simples[i].Count = i;
simples[i].Id = i;
}
//Now do timings
Timer timer = new Timer();
GC.Collect();
GC.WaitForPendingFinalizers();
sqlMap.OpenConnection();
timer.Start();
Ibatis(simples, n, "h1");
timer.Stop();
double ibatis = 1000000 * (timer.Duration / (double)n);
sqlMap.CloseConnection();
sqlMap.OpenConnection();
timer.Start();
Ibatis(simples, n, "h2");
timer.Stop();
ibatis += 1000000 * (timer.Duration / (double)n);
sqlMap.CloseConnection();
sqlMap.OpenConnection();
timer.Start();
Ibatis(simples, n, "h2");
timer.Stop();
ibatis += 1000000 * (timer.Duration / (double)n);
sqlMap.CloseConnection();
System.Console.WriteLine("Objects: " + n + " - iBATIS DataMapper: " + ibatis.ToString("F3"));
}
System.GC.Collect();
}
private void Ibatis(Simple[] simples, int N, string runname)
{
sqlMap.BeginTransaction(false);
for (int i = 0; i < N; i++)
{
sqlMap.Insert("InsertSimple", simples[i]);
}
for (int i = 0; i < N; i++)
{
simples[i].Name = "NH - " + i + N + runname + " - " + System.DateTime.Now.Ticks;
sqlMap.Update("UpdateSimple", simples[i]);
}
for (int i = 0; i < N; i++)
{
sqlMap.Delete("DeleteSimple", simples[i].Id);
}
sqlMap.CommitTransaction(false);
}
private void DirectAdoNet(IDbConnection c, Simple[] simples, int N, string runname)
{
IDbCommand insert = InsertCommand();
IDbCommand delete = DeleteCommand();
IDbCommand select = SelectCommand();
IDbCommand update = UpdateCommand();
IDbTransaction t = c.BeginTransaction();
insert.Connection = c;
delete.Connection = c;
select.Connection = c;
update.Connection = c;
insert.Transaction = t;
delete.Transaction = t;
select.Transaction = t;
update.Transaction = t;
insert.Prepare();
delete.Prepare();
select.Prepare();
update.Prepare();
for (int i = 0; i < N; i++)
{
((IDbDataParameter)insert.Parameters[0]).Value = simples[i].Name;
((IDbDataParameter)insert.Parameters[1]).Value = simples[i].Address;
((IDbDataParameter)insert.Parameters[2]).Value = simples[i].Count;
((IDbDataParameter)insert.Parameters[3]).Value = simples[i].Date;
((IDbDataParameter)insert.Parameters[4]).Value = simples[i].Pay;
((IDbDataParameter)insert.Parameters[5]).Value = simples[i].Id;
insert.ExecuteNonQuery();
}
for (int i = 0; i < N; i++)
{
((IDbDataParameter)update.Parameters[0]).Value = "DR - " + i + N + runname + " - " + System.DateTime.Now.Ticks;
((IDbDataParameter)update.Parameters[1]).Value = simples[i].Address;
((IDbDataParameter)update.Parameters[2]).Value = simples[i].Count;
((IDbDataParameter)update.Parameters[3]).Value = simples[i].Date;
((IDbDataParameter)update.Parameters[4]).Value = simples[i].Pay;
((IDbDataParameter)update.Parameters[5]).Value = simples[i].Id;
update.ExecuteNonQuery();
}
for (int i = 0; i < N; i++)
{
((IDbDataParameter)delete.Parameters[0]).Value = simples[i].Id;
delete.ExecuteNonQuery();
}
t.Commit();
}
public void Simultaneous()
{
double ibatis = 0;
double adonet = 0;
IDbConnection _connection = sqlMap.DataSource.DbProvider.CreateConnection();
_connection.ConnectionString = sqlMap.DataSource.ConnectionString;
for (int n = 2; n < 4000; n *= 2)
{
Simple[] simples = new Simple[n];
for (int i = 0; i < n; i++)
{
simples[i] = new Simple();
simples[i].Init();
simples[i].Count = i;
simples[i].Id = i;
}
sqlMap.OpenConnection();
Ibatis(simples, n, "h0");
sqlMap.CloseConnection();
_connection.Open();
DirectAdoNet(_connection, simples, n, "j0");
_connection.Close();
sqlMap.OpenConnection();
Ibatis(simples, n, "h0");
sqlMap.CloseConnection();
_connection.Open();
DirectAdoNet(_connection, simples, n, "j0");
_connection.Close();
//Now do timings
Timer timer = new Timer();
GC.Collect();
GC.WaitForPendingFinalizers();
sqlMap.OpenConnection();
timer.Start();
Ibatis(simples, n, "h1");
timer.Stop();
ibatis = 1000000 * (timer.Duration / (double)n);
sqlMap.CloseConnection();
_connection.Open();
timer.Start();
DirectAdoNet(_connection, simples, n, "j1");
timer.Stop();
adonet = 1000000 * (timer.Duration / (double)n);
_connection.Close();
sqlMap.OpenConnection();
timer.Start();
Ibatis(simples, n, "h2");
timer.Stop();
ibatis += 1000000 * (timer.Duration / (double)n);
sqlMap.CloseConnection();
_connection.Open();
timer.Start();
DirectAdoNet(_connection, simples, n, "j2");
timer.Stop();
adonet += 1000000 * (timer.Duration / (double)n);
_connection.Close();
sqlMap.OpenConnection();
timer.Start();
Ibatis(simples, n, "h2");
timer.Stop();
ibatis += 1000000 * (timer.Duration / (double)n);
sqlMap.CloseConnection();
_connection.Open();
timer.Start();
DirectAdoNet(_connection, simples, n, "j2");
timer.Stop();
adonet += 1000000 * (timer.Duration / (double)n);
_connection.Close();
System.Console.Out.WriteLine("Objects " + n + " iBATIS DataMapper : " + ibatis.ToString("F3") + " / Direct ADO.NET: " + adonet.ToString("F3") + " Ratio: " + ((ibatis / adonet)).ToString("F3"));
}
System.GC.Collect();
}
public void Many()
{
double ibatis = 0;
double adonet = 0;
for (int n = 0; n < 5; n++)
{
Simple[] simples = new Simple[n];
for (int i = 0; i < n; i++)
{
simples[i] = new Simple();
simples[i].Init();
simples[i].Count = i;
simples[i].Id = i;
}
sqlMap.OpenConnection();
Ibatis(simples, n, "h0");
sqlMap.CloseConnection();
IDbConnection _connection = sqlMap.DataSource.DbProvider.CreateConnection();
_connection.ConnectionString = sqlMap.DataSource.ConnectionString;
_connection.Open();
DirectAdoNet(_connection, simples, n, "j0");
_connection.Close();
sqlMap.OpenConnection();
Ibatis(simples, n, "h0");
sqlMap.CloseConnection();
_connection.Open();
DirectAdoNet(_connection, simples, n, "j0");
_connection.Close();
// now do timings
int loops = 30;
Timer timer = new Timer();
for (int runIndex = 1; runIndex < 4; runIndex++)
{
GC.Collect();
GC.WaitForPendingFinalizers();
timer.Start();
for (int i = 0; i < loops; i++)
{
sqlMap.OpenConnection();
Ibatis(simples, n, "h" + runIndex.ToString());
sqlMap.CloseConnection();
}
timer.Stop();
ibatis += 1000000 * (timer.Duration / (double)loops);
GC.Collect();
GC.WaitForPendingFinalizers();
timer.Start();
for (int i = 0; i < loops; i++)
{
_connection.Open();
DirectAdoNet(_connection, simples, n, "j" + runIndex.ToString());
_connection.Close();
}
timer.Stop();
adonet += 1000000 * (timer.Duration / (double)loops);
}
}
System.Console.Out.WriteLine("iBatis DataMapper : " + ibatis.ToString("F3") + " / Direct ADO.NET: " + adonet.ToString("F3") + " Ratio: " + ((ibatis / adonet)).ToString("F3"));
System.GC.Collect();
}
