There's a nice series of LINQ performance articles from Rico Mariani. I haven't run my own speed tests yet, but he claims that they've increased the speed markedly from Beta 1 too Beta 2.Beta 1 was running select queries at about 1/8 the speed of a DataReader (LINQ uses datareaders under the covers), but they have made a 3.8x improvement under the covers with Beta 2.He discusses compiled queries where you can define the query, and execute it later with parameters (sounds a bit like a stored procedure!) This means that LINQ doesn't need to generate the SQL each time the query is called, thus saving time on each execution. By using compiled queries you can achieve a 6.6x improvement over beta 1, or a speed of around 93% that of a raw datareader.The series of articles is here
Part 1,
Part 2,
Part 3,
Part 4,
Part 5.(I've posted this mainly as a bookmark for myself).[tags]LINQ, Orcas, .net 3.5, database[/tags]