I have a webpage that is taking way too long and need to optimize it. Because uninformed optimizing is the devil, I need to know what exactly is holding me down. A quick glance showed me that it is probably an sql2linq query that is most likely causing the trouble.
What are techniques of pinning the performance problem in this case? Are there specific things you experienced Linq2sql is not that good at and thus should be avoided?
If needed, I can give more detail on the code that builds the query.