public bool ComplicatedLinqFast(Stopwatch watch, int repeatCount, int takeCount) { watch.Start(); for (var i = 0; i < repeatCount; i++) { using (var db = new LoWcfContext(TrackChanges)) { var q = ( from n1 in db.Narrows join n2 in db.Narrows 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 LoWcfContext(TrackChanges)) { var q = ( from n1 in db.Narrows where n1.ID < 100 select n1.ID ) .Take(takeCount); foreach (var item in q) { } } } 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 LoWcfContext(TrackChanges)) await db.Narrows.Where(t => t.ID == 1).Select(t => t.ID).FirstAsync(); } watch.Stop(); return(true); }
public bool GetSingleColumnSlow(Stopwatch watch, int repeatCount, int takeCount) { watch.Start(); for (var i = 0; i < repeatCount; i++) { using (var db = new LoWcfContext(TrackChanges)) db.Narrows.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 LoWcfContext(TrackChanges)) await db.WideLongs.Take(takeCount).ForEachAsync(item => {}); } 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 LoWcfContext(TrackChanges)) { var q = ( from n in db.NarrowLongs join w in db.WideLongs 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.NarrowLongs join w in db.WideLongs 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 bool GetSingleColumnParam(Stopwatch watch, int repeatCount, int takeCount) { watch.Start(); using (var db = new LoWcfContext(TrackChanges)) for (var i = 0; i < repeatCount; i++) { var id = 1; var p = 2; db.Narrows.Where(t => t.ID == id && t.Field1 == p).Select(t => t.ID).AsEnumerable().First(); } 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 LoWcfContext(TrackChanges)) foreach (var item in db.WideLongs.Take(takeCount)) { } } watch.Stop(); return(true); }
public async Task <bool> GetSingleColumnParamAsync(Stopwatch watch, int repeatCount, int takeCount) { watch.Start(); using (var db = new LoWcfContext(TrackChanges)) for (var i = 0; i < repeatCount; i++) { var id = 1; var p = 2; await db.Narrows.Where(t => t.ID == id && t.Field1 == p).Select(t => t.ID).FirstAsync(); } watch.Stop(); return(true); }
public override void SetUp() { LoWcfContext.OpenHost(); }