Update: an even better solution has been provided by ivowiblo in the comments below making use of DataLoadOptions! Be sure to check that out! – Original post as follows:

It might seem like a sudden change for me to blog about C# and ASP.NET MVC but it’s what I work with at my work and I’m loving it. Plus I haven’t had the inspiration to use django in months. From now on, most posts will be about C#, ASP.NET MVC, HTML, CSS, and many other acronyms…

This may be already have been obvious to you but I had been working with a slow query for a number of days before I really realised what was going on.

Here’s the scenario: You want to show a list of two or more fields from different sql tables on a single page but for some reason the longer the list gets, the page just keeps taking longer and longer to load.

Continue reading »

© 2011 athe.la blog Suffusion theme by Sayontan Sinha