Good day, I am starting to use linq and when I execute my query. This takes up to 1 hour. Does anyone know how I can optimize it?
if (db.GpsInfo.Any(i => i.device_id == id))
{
var gpsinf = db.GpsInfo
.Where(i => i.device_id == id)
.OrderByDescending(i => i.date)
.Select(d => new Types.GpsInfoRequest
{
device_id = d.device_id,
date = d.date,
longitude = d.longitude,
latitude = d.latitude,
speed = d.speed
})
.Take(last)
.ToList();
return gpsinf;
}return new List<GpsInfoRequest>();