Databases

4 posts tagged

Using SqlDataReader NextResult to improve performance

by John Avis | July 31, 2014

On database-driven websites it is commonplace to execute multiple database queries to generate just one page. For example, on the home page of an ecommerce website you might get a list of categories, a list of banner advertisements to display, a list of featured products, and a list of top selling products. I investigate whether it was more efficient to put these multiple queries into one stored procedure and use the SqlDataReader's Next Result method to get the data all in one go.

Linq to SQL - Order By Nulls Last

by John Avis | April 7, 2011

Using Linq to SQL and need to order by NULLS last?

Date Title Tags

About me

...mostly about web development and programming, with a little bit of anything else related to the Internet, computers and technology.

Subscribe

Get the latest posts delivered to your inbox.