public bool ComplicatedLinqFast(Stopwatch watch, int repeatCount, int takeCount)
{
watch.Start();
for (var i = 0; i < repeatCount; i++)
{
using (var db = new EF6Context(TrackChanges))
{
var q =
(
from n1 in db.Narrow
join n2 in db.Narrow on new { n1.ID, n1.Field1 } equals new { n2.ID, n2.Field1 }
where n1.ID < 100 && n2.Field1 <= 50
group n1 by n1.ID into gr
select new
{
gr.Key,
Count = gr.Count()
}
)
.OrderBy(n1 => n1.Key)
.Skip(1)
.Take(takeCount);
foreach (var item in q)
{
}
}
}
watch.Stop();
return(true);
}
public bool SimpleLinqQuery(Stopwatch watch, int repeatCount, int takeCount)
{
watch.Start();
for (var i = 0; i < repeatCount; i++)
{
using (var db = new EF6Context(TrackChanges))
{
var q =
(
from n1 in db.Narrow
where n1.ID < 100
select n1.ID
)
.Take(takeCount);
foreach (var item in q)
{
}
}
}
watch.Stop();
return(true);
}
public bool ComplicatedLinqSlow(Stopwatch watch, int repeatCount, int takeCount, int nRows)
{
watch.Start();
for (var i = 0; i < repeatCount; i++)
{
using (var db = new EF6Context(TrackChanges))
{
var q =
(
from n in db.NarrowLong
join w in db.WideLong on n.Field1 equals w.Field1
where
n.ID >= 0 && n.ID <= nRows &&
!new[] { 0, 20, 50, 187635 }.Contains(w.Field1)
select new
{
n.ID,
w.Field1
}
)
.Union
(
from n in db.NarrowLong
join w in db.WideLong on n.Field1 equals w.Field1
where
n.ID >= 0 && n.ID <= nRows &&
!new[] { 0, 240, 500, 18635 }.Contains(w.Field1)
select new
{
n.ID,
w.Field1
}
)
.OrderByDescending(n1 => n1.Field1)
.Skip(1000)
.Take(takeCount);
foreach (var item in q)
{
}
}
}
watch.Stop();
return(true);
}
public async Task <bool> GetSingleColumnSlowAsync(Stopwatch watch, int repeatCount, int takeCount)
{
// if (NoTracking)
// return false;
watch.Start();
for (var i = 0; i < repeatCount; i++)
{
using (var db = new EF6Context(TrackChanges))
await db.Database.SqlQuery <int>(GetSingleColumnSql).FirstAsync();
}
watch.Stop();
return(true);
}
public bool GetSingleColumnFast(Stopwatch watch, int repeatCount, int takeCount)
{
// if (!TrackChanges)
// return false;
watch.Start();
using (var db = new EF6Context(TrackChanges))
for (var i = 0; i < repeatCount; i++)
{
db.Database.SqlQuery <int>(GetSingleColumnSql).First();
}
watch.Stop();
return(true);
}
public async Task <bool> GetSingleColumnSlowAsync(Stopwatch watch, int repeatCount, int takeCount)
{
watch.Start();
for (var i = 0; i < repeatCount; i++)
{
using (var db = new EF6Context(TrackChanges))
{
var q = !TrackChanges?db.Narrow.AsNoTracking() : db.Narrow;
await db.Narrow.AsNoTracking().Where(t => t.ID == 1).Select(t => t.ID).FirstAsync();
}
}
watch.Stop();
return(true);
}
public bool GetSingleColumnFast(Stopwatch watch, int repeatCount, int takeCount)
{
watch.Start();
using (var db = new EF6Context(TrackChanges))
{
var q = !TrackChanges?db.Narrow.AsNoTracking() : db.Narrow;
for (var i = 0; i < repeatCount; i++)
{
q.Where(t => t.ID == 1).Select(t => t.ID).AsEnumerable().First();
}
}
watch.Stop();
return(true);
}
public async Task <bool> GetWideListAsync(Stopwatch watch, int repeatCount, int takeCount)
{
watch.Start();
for (var i = 0; i < repeatCount; i++)
{
using (var db = new EF6Context(TrackChanges))
{
var q = !TrackChanges?db.WideLong.AsNoTracking() : db.WideLong;
await q.Take(takeCount).ForEachAsync(item => {});
}
}
watch.Stop();
return(true);
}
public bool GetWideList(Stopwatch watch, int repeatCount, int takeCount)
{
watch.Start();
for (var i = 0; i < repeatCount; i++)
{
using (var db = new EF6Context(TrackChanges))
{
var q = !TrackChanges?db.WideLong.AsNoTracking() : db.WideLong;
foreach (var item in q.Take(takeCount))
{
}
}
}
watch.Stop();
return(true);
}
public async Task <bool> GetSingleColumnParamAsync(Stopwatch watch, int repeatCount, int takeCount)
{
watch.Start();
using (var db = new EF6Context(TrackChanges))
{
var q = !TrackChanges?db.Narrow.AsNoTracking() : db.Narrow;
for (var i = 0; i < repeatCount; i++)
{
var id = 1;
var p = 2;
await q.Where(t => t.ID == id && t.Field1 == p).Select(t => t.ID).FirstAsync();
}
}
watch.Stop();
return(true);
}
public async Task <bool> GetWideListAsync(Stopwatch watch, int repeatCount, int takeCount)
{
if (!TrackChanges && takeCount >= 1000)
{
return(false);
}
var sql = GetWideListSql(takeCount);
watch.Start();
for (var i = 0; i < repeatCount; i++)
{
using (var db = new EF6Context(TrackChanges))
await db.WideLong.SqlQuery(sql).ForEachAsync(item => { });
}
watch.Stop();
return(true);
}
public bool GetSingleColumnParam(Stopwatch watch, int repeatCount, int takeCount)
{
// if (NoTracking)
// return false;
watch.Start();
using (var db = new EF6Context(TrackChanges))
{
for (var i = 0; i < repeatCount; i++)
{
db.Database
.SqlQuery <int>(GetParamSql,
new SqlParameter("@id", 1),
new SqlParameter("@p", 2))
.First();
}
}
watch.Stop();
return(true);
}
public bool GetWideList(Stopwatch watch, int repeatCount, int takeCount)
{
if (!TrackChanges && takeCount >= 1000)
{
return(false);
}
var sql = GetWideListSql(takeCount);
watch.Start();
for (var i = 0; i < repeatCount; i++)
{
using (var db = new EF6Context(TrackChanges))
foreach (var item in db.WideLong.SqlQuery(sql))
{
}
}
watch.Stop();
return(true);
}
