static void Main()
{
var context = new AdsEntities();
long time = SlowOrder(context);
Console.WriteLine(time);
time = FastOrder(context);
Console.WriteLine(time);
Console.ReadLine();
}
public static long FastOrder(AdsEntities context)
{
context.Database.SqlQuery <string>("CHECKPOINT");
context.Database.SqlQuery <string>("DBCC DROPCLEANBUFFERS");
context.SaveChanges();
var stopWatch = new Stopwatch();
stopWatch.Start();
var sortedAds = context.Ads
.Where(a => a.AdStatus.Status == "Published")
.OrderBy(a => a.Date)
.Select(a => new
{
a.Title,
Category = a.Category != null ? a.Category.Name : null,
Town = a.Town != null ? a.Town.Name : null,
Date = a.Date
})
.ToList();
long time = stopWatch.ElapsedMilliseconds;
return(time);
}