Hi 

we have an intranet solution using Umbraco 4.5.2 ..

Inside this site we are using some Linq sql to get data from the content..

here is teh exampel :

var nyheder = from n in db.Nyheds

                              where n.VisIAfdelinger.Contains(AfdelingerID.ToString())

                              orderby n.ForceFrontPage descending, n.UpdateDate descending //n.CreateDate descending

                              select n;

                return nyheder.ToList();

My problem is that the decending in the Linq Sql makes the whole site really slow !! is there an alternativ to this LinqSql ??

Can I get the data from the database and then sort it afterwards ?? 

Hope somebody can help me !!

/arno