public void TestPersistence()
{
var connectionString = ConfigurationManager.AppSettings["ConnectionString"];
var p = new SqlPersistence
{
ConnectionString = connectionString
};
var clientId = Guid.NewGuid().ToString();
var md5 = new byte[16] {
0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 1, 2, 3, 4, 5, 6
};
var msg = new byte[] { 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8 };
var headers = new NameValueCollection();
headers.Add("hello", "world");
var sw = new Stopwatch();
sw.Start();
using (var scope = new TransactionScope())
{
p.InsertMessage(DateTime.UtcNow, clientId, md5, msg, headers);
scope.Complete();
}
Trace.WriteLine("insert:" + sw.ElapsedTicks);
sw.Reset();
NameValueCollection outHeaders;
byte[] outMessage;
sw.Start();
using (var scope = new TransactionScope())
{
p.AckMessage(clientId, md5, out outMessage, out outHeaders);
scope.Complete();
}
Trace.WriteLine("ack:" + sw.ElapsedTicks);
sw.Reset();
sw.Start();
int deleted;
using (var scope = new TransactionScope())
{
deleted = p.DeleteDeliveredMessages(DateTime.UtcNow - TimeSpan.FromSeconds(2));
scope.Complete();
}
sw.Stop();
Trace.WriteLine("delete:" + sw.ElapsedTicks);
if (deleted > 0)
{
Trace.WriteLine("DELETED ROWS:" + deleted);
}
}
public void TestPersistence()
{
var connectionString = ConfigurationManager.AppSettings["ConnectionString"];
var p = new SqlPersistence
{
ConnectionString = connectionString
};
var clientId = Guid.NewGuid().ToString();
var msg = new byte[] { 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8 };
var headers = new Dictionary <string, string> {
{ "hello", "world" }
};
var sw = new Stopwatch();
sw.Start();
using (var scope = new TransactionScope())
using (var msgStream = new MemoryStream(msg))
{
p.InsertMessage(clientId, DateTime.UtcNow, msgStream, headers);
scope.Complete();
}
Trace.WriteLine("insert:" + sw.ElapsedTicks);
sw.Reset();
IDictionary <string, string> outHeaders;
byte[] outMessage;
sw.Start();
using (var scope = new TransactionScope())
{
p.AckMessage(clientId, out outMessage, out outHeaders);
scope.Complete();
}
Trace.WriteLine("ack:" + sw.ElapsedTicks);
sw.Reset();
sw.Start();
int deleted;
using (var scope = new TransactionScope())
{
deleted = p.DeleteDeliveredMessages(DateTime.UtcNow - TimeSpan.FromSeconds(2));
scope.Complete();
}
sw.Stop();
Trace.WriteLine("delete:" + sw.ElapsedTicks);
if (deleted > 0)
{
Trace.WriteLine("DELETED ROWS:" + deleted);
}
}
public void TestPersistence()
{
var connectionString = ConfigurationManager.AppSettings["ConnectionString"];
var p = new SqlPersistence
{
ConnectionString = connectionString
};
var clientId = Guid.NewGuid().ToString();
var md5 = new byte[16] {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 1, 2, 3, 4, 5, 6};
var msg = new byte[] {8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8};
var headers = new NameValueCollection();
headers.Add("hello", "world");
var sw = new Stopwatch();
sw.Start();
using (var scope = new TransactionScope())
{
p.InsertMessage(DateTime.UtcNow, clientId, md5, msg, headers);
scope.Complete();
}
Trace.WriteLine("insert:" + sw.ElapsedTicks);
sw.Reset();
NameValueCollection outHeaders;
byte[] outMessage;
sw.Start();
using (var scope = new TransactionScope())
{
p.AckMessage(clientId, md5, out outMessage, out outHeaders);
scope.Complete();
}
Trace.WriteLine("ack:" + sw.ElapsedTicks);
sw.Reset();
sw.Start();
int deleted;
using (var scope = new TransactionScope())
{
deleted = p.DeleteDeliveredMessages(DateTime.UtcNow - TimeSpan.FromSeconds(2));
scope.Complete();
}
sw.Stop();
Trace.WriteLine("delete:" + sw.ElapsedTicks);
if (deleted > 0)
Trace.WriteLine("DELETED ROWS:" + deleted);
}
public void TestPersistence()
{
var connectionString = ConfigurationManager.AppSettings["ConnectionString"];
var p = new SqlPersistence
{
ConnectionString = connectionString
};
var clientId = Guid.NewGuid().ToString();
var msg = new byte[] {8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8};
var headers = new Dictionary<string,string> {{"hello", "world"}};
var sw = new Stopwatch();
sw.Start();
using (var scope = new TransactionScope())
using(var msgStream = new MemoryStream(msg))
{
p.InsertMessage(clientId,DateTime.UtcNow, msgStream, headers);
scope.Complete();
}
Trace.WriteLine("insert:" + sw.ElapsedTicks);
sw.Reset();
IDictionary<string,string> outHeaders;
byte[] outMessage;
sw.Start();
using (var scope = new TransactionScope())
{
p.AckMessage(clientId, out outMessage, out outHeaders);
scope.Complete();
}
Trace.WriteLine("ack:" + sw.ElapsedTicks);
sw.Reset();
sw.Start();
int deleted;
using (var scope = new TransactionScope())
{
deleted = p.DeleteDeliveredMessages(DateTime.UtcNow - TimeSpan.FromSeconds(2));
scope.Complete();
}
sw.Stop();
Trace.WriteLine("delete:" + sw.ElapsedTicks);
if (deleted > 0)
Trace.WriteLine("DELETED ROWS:" + deleted);
}